I have several mySQL database's
Each database has 1 table with 10 Distinct columns.
In one of the columns, there are many (up to 20) different names (categories)
Each Category has hundreds/thousands of rows.
I need a script made, which will sort the distinct columns and move all of the rows related to that column (category) to a new table.
So, If one of my databases has 20 different "distinct" categories, but a total of 15K combined rows. After the sorting I will have 20 different tables. Each with the rows for it's category.
Hope this makes sense. If you have any other questions, send PM.