Please enable JavaScript.
Coggle requires JavaScript to display documents.
Node JS (mysql package (dynamic INSERT (query ("INSERT INTO tableName…
Node JS
mysql package
connecting
-
connection
connection = mysql.CreateConnection({
host: "localhost",
user: "username",
password: "password",
database: "dbname"
});
running queries
-
connection.query(q, function(error, results, fields) {
if (error) throw error;
console.log(results[idx].columnName);
});
-
-
-
dynamic INSERT
-
-
connection.query(q, person, function(error, results, fields) {
code
})'
checking sql
send to database
assign query to variable
var end_result = connection.query(q, obj, function)
-
bulk insert
-
connection.query
-
query
"INSERT INTO (col1, col2) VALUES ?"
connection.query(q, [nested_array], function(err, result) {
code
})
-
-
-
-
-
-
-