Need Help Modifying Data in MySQL table with millions of records
Budget: $15 – $25 USD
Hi. I need help modifying data in a MySql table with millions of rows and records. Things like copying the table to a new table but only 3 columns (so this is a way to delete columns in a big table).
Plus, I want to add a 24 character unique alphanumeric code/ID to each record.
Finally, we have Categories in a column, which repeat for some of the items/records so I want to somehow get all the unique Categories and put them into their own table and use the new 24 character unique ID to sort of bind the new Categories table to this master table.
I have a pretty good VPS because I've figured out how to do a lot of other data modifications to the table myself.
Plus, I want to add a 24 character unique alphanumeric code/ID to each record.
Finally, we have Categories in a column, which repeat for some of the items/records so I want to somehow get all the unique Categories and put them into their own table and use the new 24 character unique ID to sort of bind the new Categories table to this master table.
I have a pretty good VPS because I've figured out how to do a lot of other data modifications to the table myself.