Update a column in MySQL

by

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

More Related Contents:

  1. Insert into a MySQL table or update if exists
  2. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  3. MySQL trigger On Insert/Update events
  4. Recreating a query using INNER JOIN? [duplicate]
  5. Create a Cumulative Sum Column in MySQL
  6. Equivalent of explode() to work with strings in MySQL
  7. 1064 error in CREATE TABLE … TYPE=MYISAM
  8. mysql select dynamic row values as column names, another column as value
  9. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  10. Setting up MySQL and importing dump within Dockerfile
  11. MySQL DELETE FROM with subquery as condition
  12. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  13. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  14. Simple Random Samples from a Sql database
  15. node.js mysql error: ECONNREFUSED
  16. Relational database design multiple user types
  17. Checking multiple columns for one value
  18. What is better in MYSQL count(*) or count(1)?
  19. How to deploy local MySQL database to Heroku
  20. Should I use MySQL blob field type?
  21. MySQL Cannot drop index needed in a foreign key constraint
  22. MySQL Insert & Joins
  23. Does MySQL overwrite a column of same value on update?
  24. How to make join queries using Sequelize on Node.js
  25. mysql like performance boost
  26. MySQL selecting yesterday’s date
  27. Does MySQL included with MAMP not include a config file?
  28. How do I write an SP in phpMyAdmin (MySQL)?
  29. GRANT with database name wildcard in MySQL?
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment