I have a data feed that I read once a week. I want to load this in to a temp_table and then update the main production table.
With this I need to update existing records, insert new records and mark records that don't exist anymore for deletion(I don't want to to automatically delete them).
what is the best way to approach this, is it to attempt to do each step on its own? or is there a more efficient method that I could use with in MYSQL.
Thanks
JaChNo