Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # npm i mysql
- # import mysql
- mysql = require('mysql');
- # mysql params
- const mysqlParams = {
- host: 'host',
- user: 'user',
- password: 'pass',
- database: 'database'
- };
- const con = mysql.createConnection(mysqlParams);
- con.connect(function(err) { if (err) throw err;});
- #create query
- let query = `select * from table`;
- #get query with callback
- con.query(query, function (err, result, fields) {
- if (err) throw err;
- console.log(result);
- });
Add Comment
Please, Sign In to add comment