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]