Update a column in MySQL

Question

I have a table table1 with three columns and a bunch of rows    key col col a col b    I want to update col a with a set of values  i e  leaving col b unchanged   something like this   INSERT INTO table1 AS t1  key col  col a  VALUES   k1    foo      k2    bar       But it doesn t work  how do I do this

User · 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

User · Answer

UPDATE table1 SET col a    newvalue    Add a WHERE condition if you want to only update some of the rows

User · Answer

if you want to fill all the column    update  column  set  info  where keyID  0

User · Answer

If you want to update data you should use UPDATE command instead of INSERT

User · Answer

This is what I did for bulk update   UPDATE tableName SET isDeleted   1 where columnName in   430903GW4j683537882   430903GW4j667075431   430903GW4j658444015

[mysql] Update a column in MySQL

Examples related to mysql

Examples related to insert-update