Dear MySQL wizards, I have two tables, call them A and B. The database structure is identical. I want the records in B to overwrite the records in (REPLACE INTO) A.
This is the statement that does NOT work. REPLACE INTO a SELECT b.* FROM b WHERE a.field1 = b.field1 I also tried this with the last the conditional statement reversed. MySQL doesn't like my syntax. The field names in A are identical to B. TIA for any help. -- Andrew Lietzow The ACL Group, Inc. --------------------------------------------------------------------- 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