Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- npm install mysql
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "localhost",
- user: "yourusername",
- password: "yourpassword",
- database: "mydb"
- });
- con.connect(function(err) {
- if (err) throw err;
- console.log("Connected!");
- var sql = "INSERT INTO customers (name, address) VALUES ('Company Inc', 'Highway 37')";
- con.query(sql, function (err, result) {
- if (err) throw err;
- console.log("1 record inserted");
- });
- });
Add Comment
Please, Sign In to add comment