How to insert values from one table to another table if that particular value doesn't exists and if exists update value of one column of that row

Asked Sep 09 '17 at 10:06

Active Sep 09 '17 at 10:23

Viewed 40 times

How to insert values from one table to another table if that particular value doesn't exists and if exists update value of one column of that row.

I am trying to find distinct rows from one table and store them in another table. But if that value already exists in the new Table, then i want to add 1 to the count column (eg:: if 1, then 1+1=2).. and if doesn't exists the insert in a row.

asked Sep 09 '17 at 10:06

Rajesh Mishra

Have a look at the Insert .. on duplicate key update syntax in the manual. – P.Salmon Sep 09 '17 at 10:13
And combine the above with insert ... select ... and you are done. See the duplicate questions. – Shadow Sep 09 '17 at 10:24

How to insert values from one table to another table if that particular value doesn't exists and if exists update value of one column of that row

0 Answers0