var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '',
database : 'mysql'
}); //连接数据库
connection.connect(); //连接
connection.query("update ds_first set name='wodepig' where name='syx'", function (error, results, fields) {
if (error) throw error;
console.log('The solution is: ', results);
});
var sql = 'insert into ds_first(name,age) values ?';
var value =[['123','12']];
connection.query(sql,[value], function (error, results, fields) {
if (error) throw error;
console.log(results);
});
node.js 控制数据库mysql
最新推荐文章于 2024-07-13 10:38:18 发布