I have an existing application where I have a MySQL table recording CIP data from 10 unique CIP systems using transaction groups to insert data into the table called CipRunData
Each of the 10 CIP systems has a unique identifier in a column SystemID, where CIP# 1 ( SystemID=0) CIP#10 ( SystemID = 9)
Due to the shear size of the CipRunData table, I want to break out the one global table and create 10 unique tables called CipRunData0 to CipRunData9 with the identical structure as CipRunData
I need to preserve any previously recorded CIP run data , so what I I really need to do in plain English is:
Copy all data from: CipRunData WHERE System ID = 0 into CipRunData0
Copy all data from: CipRunData WHERE System ID = 1 into CipRunData1
Copy all data from: CipRunData WHERE System ID = 9 into CipRunData9.
I am an SQL novice, so is there a way to do this from within MySQL WorkBench?