INSERT INTO fails with node-mysql

by

Pay attention to the documentation of node-mysql:

If you paid attention, you may have noticed that this escaping allows you to do neat things like this:

var post  = {id: 1, title: 'Hello MySQL'};
var query = connection.query('INSERT INTO posts SET ?', post, function(err, result) {
  // Neat!
});
console.log(query.sql); // INSERT INTO posts SET `id` = 1, `title` = 'Hello MySQL'

Notice that they use SET instead of VALUES. INSERT INTO ... SET x = y is a valid MySQL query, while INSERT INTO ... VALUES x = y is not.

More Related Contents:

  1. Use promise to process MySQL return value in node.js
  2. MySQL giving “read ECONNRESET” error after idle time on node.js server
  3. How can i write in NodeJS with MongoDB the following MySQL Select?
  4. Inserting multiple rows in mysql
  5. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  6. MySQL with Node.js
  7. Preventing SQL injection in Node.js
  8. node-mysql multiple statements in one query
  9. nodejs mysql Error: Connection lost The server closed the connection
  10. How do I do a bulk insert in mySQL using node.js
  11. Column count doesn’t match value count at row 1
  12. Insert into multiple tables in one query
  13. Node.js can’t authenticate to MySQL 8.0
  14. node.js mysql error: ECONNREFUSED
  15. How to auto generate migrations with Sequelize CLI from Sequelize models?
  16. How to access a RowDataPacket object
  17. Retrieve last inserted id with Mysql
  18. How to pass parameters to mysql query callback in nodejs
  19. Making changes to multiple records based on change of single record with SQL
  20. node.js + mysql connection pooling
  21. connect ECONNREFUSED – node js , sql
  22. What are differences between INSERT and UPDATE in MySQL?
  23. How to make join queries using Sequelize on Node.js
  24. NodeJS MySQL Dump
  25. Node.js connect to MySQL Docker container ECONNREFUSED
  26. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  27. How to create and insert a JSON object using MySQL queries?
  28. Error in MySQL library for Node.js
  29. MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields
  30. Counting associated entries with Sequelize

Leave a Comment