Does anyone know the easiest way to copy a column in mysql?

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.

I guess one possible way is to do a select and output to a file and then
read from the file for input into col2.

Thank you..



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to