Member Avatar for mpc123

I have a very large table and would need to split into lots of tables.

The large table has lots of fields of which `Model.ID` gives a number of the product and this is repeated lots of times with other fields used in the row.

I need to create lots of new tables based on the Model ID field and its associated fields in that row need to be kept together. So if `Model.ID` = 1614 then a new table will be created and inserted into that will be all the rows that have that.

Obviously i need code that does them all and the `model.ID` dont go in order and are pretty random.


Could anybody help please, as this is way above what i can do php wise.

  • 2 Contributors
  • 3 Replies
  • 90 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by mpc123
Member Avatar for mpc123

can anybody help with this?

Member Avatar for pritaeas

You can use a query like

INSERT INTO new_table (modelid, column2, column3) SELECT modelid, column2, column3 FROM main_table WHERE modelid = 1614

You can get the unique model id's

SELECT DISTINCT modelid FROM main_table

Hope this will get you started.

Edited by pritaeas because: n/a
Member Avatar for mpc123

that really does help thank you very much

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.