Why do you need to do that? If all that matters is which column the data is, use ALTER TABLE to rename them.
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, 01 June, 2003 22:18 Subject: swapping data how can I swap the data between to columns in the same table? Ted -- 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]
