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 keys, Product_Id, Product_Date. I've been using Replace but that will
replace all the matching rows in TblOld with TblNew even if the rows are
identical. I was hoping there was some sort of row CheckSum so I could
compare the checksum of TblOld rows to the checksum in TblNew rows and if
they are different, do a Replace on those rows. If the checksums are the
same I'd skip them, and if TblNew doesn't have the rows, I'd insert them.
Does this make sense? Is this possible or is there a better way to sync a
table in the same database? Only TblOld needs to be updated.
Mike
MySQL 5
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
