prophecym

I appreciate your answers. But, how exactly you would execute this process. Would you share the steps and the codes?

This is bugging me for some time now. I would love some advise. Here is the situation: I have my Contacts table in my database. And using a CSV file, I need to import more people into this table time to time. The problem is, how would you check to see whether you already have the record in the Contacts table? If so, how would you update the record's some or all fields(basically the fields need to be updated) based on the record in the CSV file. This actually gets more complicated when the Companies table gets into the picture. If you have a record in the CSV file which has a company not in the database yet, how would you tell it to create that company, and use that company's id# to add into that record in the Contacts table. I can elaborate this as I get your questions. But right now, I can't logically think of any way of doing this with just using MySQL. It feels like it has to have a PHP script to handle such a job. And I don't know that script.

Thank you very much, you just saved me from a ton of work.

:confused: What was I thinking But I know that you know what I mean.

I have a mind blank. I couldn't get this to work. And I couldn't find If it is not too much trouble, would you write down what exactly should I write down?

Hi everyone, I am sure there's a way to do this. I just don't know how. Any help is appreciated. I have 2 tables that need to be compared based on their one particular field. Say this is the 'name' field. During the comparison of these two tables, it needs to find the same records. Then, change the data in the another field to something else. Table A Table B id | name | boolean name As you can see above, the name field needs to be compared. When it finds the same records, the 'boolean' field in the Table A needs to be changed whatever I set to. (If it is 1, change it to 2) I would love to know how to do this. Thank you.