Re: Help with REPLACE INTO statement syntax

2002-05-27 Thread Andrew Lietzow
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

Re: Help with REPLACE INTO statement syntax

2002-05-23 Thread Paul DuBois
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