Search the Community
Showing results for tags 'mysql update records'.
Found 1 result
-
I have a mysql table with the name of the fruit as primary key. If I'm given a new table with NEW names of fruits, I want those to go into my table. However, if the primary key (the fruit) already exists in my first table, I don't want it updated. For example: Table 1: apple red olive green Table 2: olive black lemon yellow Since table 1 already has an olive, I don't want the olive from table 2 inserted (even though it's a different color), but I want the lemon inserted into table 1 What is the correct mysql syntax, please? Thank you!!
