Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- module.exports = function(mysql) {
- var client = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: '12345'
- });
- return client;
- }
- var client = require('./connectMysql');
- client.query("USE node");
- client.query("INSERT INTO test(content) VALUES(?)", ['the content'],
- function(err, info) {
- if(err)
- return handle_error(err);
- console.log(info.insertId);
- });
- client.query('UPDATE test SET content = ?', ['new content'], function(err, info) {
- if(err)
- return handle_error(err);
- console.log(info.insertId);
- });
- client.end();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement