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

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

Help with REPLACE INTO statement syntax

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