How to add a where clause in a MySQL Insert statement?

by

In an insert statement you wouldn’t have an existing row to do a where claues on? You are inserting a new row, did you mean to do an update statment?

update users set username="JACK" and password='123' WHERE id='1';

More Related Contents:

  1. SELECTING with multiple WHERE conditions on same column
  2. MySQL Conditional Insert
  3. Get the new record primary key ID from MySQL insert query?
  4. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  5. Detect if value is number in MySQL
  6. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  7. MySql Table Insert if not exist otherwise update
  8. Increment a database field by 1
  9. Prevent auto increment on MySQL duplicate insert
  10. MySQL trigger On Insert/Update events
  11. How do I get the ID of multiple inserted rows in MySQL?
  12. MySQL trigger to update a field to the value of id
  13. How to insert data to MySQL with auto-incremented column(field)?
  14. MySQL Select last 7 days
  15. Field ‘id’ doesn’t have a default value?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. insert data from one table to another in mysql
  18. Reserved word in column name – insert into MySQL [duplicate]
  19. MySQL – ORDER BY values within IN()
  20. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  21. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  22. Mysql insert into 2 tables
  23. MySQL – insert data from another table merged with constants
  24. Insert data into table with result from another select query
  25. MySQL: Insert datetime into other datetime field
  26. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  27. Incorrect integer value: ” for column ‘id’ at row 1
  28. “Unknown column in ‘field list'”, but column does exist
  29. MySQL: how to index an “OR” clause
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment