>I have a table (table1) which has 4 columns, I want to copy all the >contents of col1 into col2. >Col3 is the primary unique key, so the copy has to keep the data matched >with col3.
Sounds like what you want to do is
update table1 set col2 = col1;
which will copy the contents of col1 in each record to col2.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
