Guest User

Untitled

a guest
Oct 31st, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. # npm i mysql
  2.  
  3. # import mysql
  4. mysql = require('mysql');
  5.  
  6. # mysql params
  7. const mysqlParams = {
  8. host: 'host',
  9. user: 'user',
  10. password: 'pass',
  11. database: 'database'
  12. };
  13.  
  14. const con = mysql.createConnection(mysqlParams);
  15. con.connect(function(err) { if (err) throw err;});
  16.  
  17. #create query
  18. let query = `select * from table`;
  19.  
  20. #get query with callback
  21. con.query(query, function (err, result, fields) {
  22. if (err) throw err;
  23. console.log(result);
  24. });
Add Comment
Please, Sign In to add comment