I am running this query on a table with 4700 records. Is running indefinately. I have to restart the computer to get it to quit.
The code used to work on an older version of MySQL I put version 5 on my new laptop and now it doesnt work....
SELECT upload_file.telephone FROM upload_file LEFT JOIN mainfile ON upload_file.telephone=mainfile.telephone WHERE mainfile.telephone is null
because I still need to insert this data into another table...
like this....
"INSERT IGNORE INTO good (telephone) (SELECT upload_file.telephone FROM upload_file LEFT JOIN mainfile ON upload_file.telephone=mainfile.telephone WHERE mainfile.telephone is null)
Is there a different way to get data from one table, check to see if it exists in another table and add it to a third table if it DOESN'T exist?
thanks
