Once each day I have a PHP application that reads a legacy dBase format file and updates a customer table in a MySQL database. The PHP script reads each dBase record, searches for it in the table, updates the field values if they have changed, or creates a new record in the MySQL database if one does not exist. So far, so good.
My problem is that occasionally a customer will be deleted in the dBase format system. In this case the "deleted" customer is still present in the MySQL database. It's never updated but it still appears in reports, etc. I could first bring all the dBase data into a separate table and then compare the two tables deleting records in the main table that have no match in the freshly imported data. I believe this would cause me to examine all the records several times between importing, checking for changes, deletions, etc. I would appreciate any suggestions for a more elegant/efficient method. There are about 20,000 records. Thanks in advance, Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
