Advertisement
Guest User

Untitled

a guest
Jan 14th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. var mysql = require('mysql');
  2.  
  3. module.exports = function(mysql) {
  4. var client = mysql.createConnection({
  5. host: 'localhost',
  6. user: 'root',
  7. password: '12345'
  8. });
  9. return client;
  10. }
  11.  
  12. var client = require('./connectMysql');
  13.  
  14. client.query("USE node");
  15.  
  16. client.query("INSERT INTO test(content) VALUES(?)", ['the content'],
  17. function(err, info) {
  18. if(err)
  19. return handle_error(err);
  20. console.log(info.insertId);
  21. });
  22.  
  23.  
  24. client.query('UPDATE test SET content = ?', ['new content'], function(err, info) {
  25. if(err)
  26. return handle_error(err);
  27. console.log(info.insertId);
  28. });
  29.  
  30. client.end();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement