Ok heres what im trying to achive i am constantly updating the information in a table but know i what know if the data im replacing it with is new, i.e. whether or not i already had the data in the table.
So my method for this is to first copy the information to be updated into another table (the 2nd table), then allow the information in the first table to updated (via deleting the current information and re-entering it).
Then i what to compare the two tables to see if there is any new rows that where not there before updating the data in the first tables. (that is i want to compare both table 1 and 2 at this point).
And this is where im struggling to find a method for comparing the two tables, to identify any new rows.
So i was wondering if anyone had any ideas on how to compare these two seperate tables.
Note: These tables are all in the same MYSQL database,
Any help would be greatly appreciated