At 21:27 -0500 5/23/02, Andrew Lietzow wrote:
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
At 21:27 -0500 5/23/02, Andrew Lietzow wrote:
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