Connection database var mysql = require (' mysql '); var connection = Mysql.createconnection ({ host: ' bdm253137448.my3w.com ',// Database address user : ' bdm253137448 ', //database user name password: ' muchengfeng123 ',//Database admin password : ' bdm253137448 _db ',//database name insecureauth:true }), Connection.connect (function (err) { if (err) { console.error (' Error connecting: ' + err.stack); return; } Console.log (' Connected as ID ' + Connection.threadid);}); var usermodsql = ' UPDATE userinfo SET username =?, pwd =? WHERE id = 1 '; var usermodsql_params = [' Hello world ', 99];//change Upconnection.query (Usermodsql,usermodsql_params,function ( Err, result) { if (err) { console.log (' [UPDATE ERROR]-', err.message); return; } Console.log ('----------UPDATE-------------'); Console.log (' UPDATE affectedrows ', result.affectedrows); Console.log (' ****************************** ');}); /close connection connection.end ();
Nodejs+mysql Getting Started instance (change)