Re: How to compare rows in different tables?

At 07:05 PM 7/12/2008, Rob Wultsch wrote: I suggest taking a look at mk-table-sync available from http://www.maatkit.org/ . On Sat, Jul 12, 2008 at 3:07 PM, mos <[EMAIL PROTECTED]> wrote: > I have 2 tables (TblNew: Memory Table, TblOld: MyISAM table) with identical > structure and each has appro

Re: How to compare rows in different tables?

I suggest taking a look at mk-table-sync available from http://www.maatkit.org/ . On Sat, Jul 12, 2008 at 3:07 PM, mos <[EMAIL PROTECTED]> wrote: > I have 2 tables (TblNew: Memory Table, TblOld: MyISAM table) with identical > structure and each has approx 75 columns in it. I need to update TblOld

How to compare rows in different tables?

I have 2 tables (TblNew: Memory Table, TblOld: MyISAM table) with identical structure and each has approx 75 columns in it. I need to update TblOld with rows in TblNew if any of the values are different, or insert the TblNew rows into TblOld if they are are missing. The two tables have the same