At 10:10 -0600 4/3/02, Chuck Barnett wrote: >Hi, how do I do the following: > >I have a table I have added a new field to, I want to take field X and copy >it to the new field for each record. What should this query look like? > >Thanks, >Chuck
UPDATE tbl_name SET y = x; --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php