Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ##Select
- var mysql = require('mysql');
- var connection = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: 'password',
- database: 'Users'
- });
- connection.connect();
- var id = '1'
- var query = connection.query('select * from articles where id = ?', id, function(err, result) {
- if (err) {
- console.error(err);
- return;
- }
- console.error(result);
- });
- ##Insert
- var mysql = require('mysql');
- var connection = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: 'password',
- database: 'Users'
- });
- connection.connect();
- var user = {
- Username: 'David Shmilowitz',
- Password: 'Password',
- };
- var query = connection.query('insert into Users set ?', user, function (err, result) {
- if (err) {
- console.error(err);
- return;
- }
- console.error(result);
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement