Advertisement
Guest User

Untitled

a guest
Nov 13th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. ##Select
  2. var mysql = require('mysql');
  3.  
  4. var connection = mysql.createConnection({
  5. host: 'localhost',
  6. user: 'root',
  7. password: 'password',
  8. database: 'Users'
  9. });
  10. connection.connect();
  11.  
  12. var id = '1'
  13. var query = connection.query('select * from articles where id = ?', id, function(err, result) {
  14. if (err) {
  15. console.error(err);
  16. return;
  17. }
  18. console.error(result);
  19. });
  20.  
  21. ##Insert
  22. var mysql = require('mysql');
  23.  
  24. var connection = mysql.createConnection({
  25. host: 'localhost',
  26. user: 'root',
  27. password: 'password',
  28. database: 'Users'
  29. });
  30. connection.connect();
  31.  
  32. var user = {
  33. Username: 'David Shmilowitz',
  34. Password: 'Password',
  35. };
  36.  
  37. var query = connection.query('insert into Users set ?', user, function (err, result) {
  38. if (err) {
  39. console.error(err);
  40. return;
  41. }
  42. console.error(result);
  43. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement