Update a column in MySQL

mysql insert-update
Muleskinner picture Muleskinner · Jun 28, 2011 · Viewed 214.1k times · Source

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?

Answer

Naveed picture Naveed · Jun 28, 2011

You have to use UPDATE instead of INSERT:

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';

Related questions

Insert into a MySQL table or update if exists

I want to add a row to a database table, but if a row exists with the same unique key I want to update the row. For example: INSERT INTO table_name (ID, NAME, AGE) VALUES(1, "A", 19); Let’s say …

Read More
INSERT INTO ... SELECT FROM ... ON DUPLICATE KEY UPDATE

I'm doing an insert query where most of many columns would need to be updated to the new values if a unique key already existed. It goes something like this: INSERT INTO lee(exp_id, created_by, location, animal, starttime, …

Read More
How do you determine if an insert or update was successful using Java and MySQL?

I am using Java to connect to a MySQL database. I am trying to insert or update data into the database. Even though I am quite sure the insert was successful, it returns false. According to the "execute" API, the …

Read More