Advertisement
jraavis

Sample Node.js DB

Apr 11th, 2020
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var mysql = require('mysql');
  2.  
  3. var con = mysql.createConnection({
  4.   host: "localhost",
  5.   user: "root",
  6.   password: "root",
  7.   database: "db_name"
  8. });
  9.  
  10. con.connect(function(err) {
  11.   if (err) throw err;
  12.   con.query("SELECT roll_number, first_name, last_name, divison  FROM students", function (err, result, fields) {
  13.     if (err) throw err;
  14.     console.log(result);
  15.   });
  16. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement