Return to Answer

You have to use UPDATE instead of INSERT:

• UPDATE Syntax

For Example:

UPDATE table1 SET col_a='k1', col_b='foo' WHERE key_col='1'; UPDATE table1 SET col_a='k2', col_b='bar' WHERE key_col='2'; 

Read following article for multiple rows update:

• Update Multiple Rows With Different Values and a Single SQL Query

You have to use UPDATE instead of INSERT:

• UPDATE Syntax

For Example:

UPDATE table1 SET col_a='k1', col_b='foo' WHERE key_col='1'; UPDATE table1 SET col_a='k2', col_b='bar' WHERE key_col='2'; 

You have to use UPDATE instead of INSERT:

• UPDATE Syntax

For Example:

UPDATE table1 SET col_a='k1', col_b='foo' WHERE key_col='1'; UPDATE table1 SET col_a='k2', col_b='bar' WHERE key_col='2'; 

You have to use UPDATE instead of INSERT:

• UPDATE Syntax

For Example:

UPDATE table1 SET col_a='k1', col_b='foo' WHERE key_col='1'; UPDATE table1 SET col_a='k2', col_b='bar' WHERE key_col='2'; 

Read following article for multiple rows update:

• Update Multiple Rows With Different Values and a Single SQL Query

You have to use UPDATE instead of INSERT:

• UPDATE Syntax

You have to use UPDATE instead of INSERT:

• UPDATE Syntax

For Example:

UPDATE table1 SET col_a='k1', col_b='foo' WHERE key_col='1'; UPDATE table1 SET col_a='k2', col_b='bar' WHERE key_col='2';