I am working on a project and i'm not sure of the best way to do what I need to.
I have a CSV file that contains addresses.
I need to compare the csv file to a MySQL table (tbl_bl).
Then if the addresses are not found in tbl_bl, I need to add the addresses to another table (tbl_wl) Only if they do not already exist in the tbl_wl table.
I can create simple SQL queries but I'm not so sure about something this complex.
Can anyone give me an idea of the best way to accomplish this?
Thanks!!
I have a CSV file that contains addresses.
I need to compare the csv file to a MySQL table (tbl_bl).
Then if the addresses are not found in tbl_bl, I need to add the addresses to another table (tbl_wl) Only if they do not already exist in the tbl_wl table.
I can create simple SQL queries but I'm not so sure about something this complex.
Can anyone give me an idea of the best way to accomplish this?
Thanks!!