I have a table let's call it (old) containing items of interest
index field (id)
another field (data)
I want the data colum to move to a normalized table (normal) that
uses id as part of a multifield primary key. So I created a data
column in the normalized table. How can I now
My first thought would be to create an empty table call it new_table set it
up like you want.
then
INSERT INTO new_table
SELECT n.*,a.data FROM normal n LEFT JOIN another a ON o.id=a.id
ORDER BY (n.id)
and then verify it got there, and drop the other tables and rename the
new_table to
normal
