KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Using a prior example? How could I insert/update a mysql table using a JSON object without manually naming the table column headers? And insure it async. var mysql = require('node-mysql'); var conn = mysql.createConnection({ ... }); var values = [ {name:'demian', email: 'demian@gmail.com', ID: 1}, {name:'john' , email: 'john@gmail.com' , ID: 2}, {name:'mark' , email: 'mark@gmail.com' , ID: 3}, {name:'pete ' , email: 'pete@gmail.com' , ID: 4} ]; // var sql = "INSERT INTO Test (name, email, n) VALUES ?"; conn.query(sql, [values], function(err) { if (err) throw err; conn.end(); })
Tags (comma-separated)
Save Edits
Cancel