Mysql_config,js
Const Mysqlconfig ={ host:' localhost ', User:' root ', password:' 123456 ' , ' 3306 ', database:' user '=mysqlconfig;
Test.js
Const MySQL = require (' MySQL ');varMysqlconfig=require ('./mysql_config ')). Mysqlconfig;vardb =mysql.createconnection (mysqlconfig);varsql = ' SELECT * from name ';//Check the articlevarUseraddsql = ' INSERT into name ' (id,uname,times) VALUES (0,?,?) ';varUseraddsql_params = [' Hahah ', 5699];d b.query (Useraddsql,useraddsql_params, (err,data)=>{//Check the numbers . if(Err) Console.log (' It's a mistake! ‘, err); Else{Console.log ('--------------------------Insert----------------------------'); Console.log (' INSERT ID: ', data); Console.log ('------------------------------------------------------------\ n '); }});d b.query (SQL, (Err,data)=>{//Check the numbers . if(Err) Console.log (' It's a mistake! ‘, err); Else{Console.log ('--------------------------SELECT----------------------------'); Console.log (' It worked! ‘, data); Console.log ('------------------------------------------------------------\ n '); }});
Nodejs MySQL Configuration reference