Jump to content

Update And Insert Question


yangkai9999

Recommended Posts

Hello,I'm a new one to use MySQL. I have a table say tab1. It includes some records, and the primary Key is ID. Now I have another table say tab2. The two tables' structures are identical. The tab2 has some records which existed in tab1 and some new records.I need to update tab1 records if the one existing from tab2 and insert the new records from tab2.How to write a single SQL to perform the task?Thank you,

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...