Copy data from one table to another

Archived Topics
1

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?

2

You’ll want to use the Create Table … Select … syntax to create and populate each table in one go.