I have a table "a" with: ItemID int unsigned not null, CommID int unsigned not null
I have a table "b" with: ItemID int unsigned not null I want to move CommID from table "a" to table "b". I've updated my schema to have CommID in "b" as well for now, and changed my code to insert the value into table "b" instead of "a". I now just need to transfer the existing information from "a" to "b". Any ideas for a one-shot SQL command to do this? I'm about to try selecting everything from "b" and the CommID from "a" as a join into a temporary table, then "REPLACE" it back into "b". -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ --------------------------------------------------------------------- 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
