node mysqlを使用してデータベースを操作する
602 ワード
var mysql =require(“mysql”); console.log(“con….“);
var connection=mysql.createConnection({
});
connection.connect(); console.log(“conned…“);
var select =“select * from test “;
connection.query(select,function(err,rows){
});
connection.end();
var connection=mysql.createConnection({
"host":"localhost",
"port":3306,
"user":"root",
"password":"wjb1234",
"database":"test"
});
connection.connect(); console.log(“conned…“);
var select =“select * from test “;
connection.query(select,function(err,rows){
if(err) console.log(err.message);
for( var i in rows){
console.log(rows[i]);
}
});
connection.end();