87,993
社区成员
发帖
与我相关
我的任务
分享
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'root',
database : 'poms'
});
connection.connect();
connection.query("select count(*) as count from pom_message_source", function(err, countResult){
var count = countResult[0].count;
console.log(count);
connection.query("select * from pom_message_source where source_id=1", function(err, results){
if(err){
console.log("查询错误");
}
console.log(results);
});
});
for(var i=0; i<1; i++){
connection.query("select * from pom_message_source where source_id=?",i+1, function(err, results){
if(err){
console.log("查询错误");
}
console.log(results);
});
}
connection.end();