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 table. Kelley Colleen Dick wrote: > 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 > ELEGANTLY update the normal table so the values for data are the same as > the old table. > > What I want to do is this: > > UPDATE normal SET data = old.data WHERE normal.id = old.id > > except that this doesn't work. > > THANKS! > > Orni > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
