MySQL Query of Nodejs

MySQL version 2.14.1 in the sample code

Reference Code

1 /**2 * Test MySQL connection3  */4 5 varMySQL = require (' MySQL ');6 varConnection =mysql.createconnection ({7Host: ' localhost ',//Server8User: ' Root ',//User name9Password: ' Root ',//PasswordTenDatabase: ' MySQL '//Database One }); AConnection.connect (function(err) { -     if(err) { -Console.error (' Error connecting: ' +err.stack); the         return; -     } -Console.log (' Connected as ID ' +connection.threadid); - }); +  - varHTTP = require (' http '); +  A varServer = Http.createserver (function(Request, response) { atResponse.writeheader, {' Content-type ': ' text/html '}); -     //querying users who are user root -Connection.query (' SELECT * from user WHERE user =? ', [' Root '],function(Err, results, fields) { -         if(err) { -             Throwerr; -         } in         vardata = '; -          for(vari = 0; i < results.length; i++) { to             varFirstresult =Results[i]; +Data + = ' User: ' + firstresult[' user ' + ' &nbsp;&nbsp; Password: ' + firstresult[' Password ' + ' <br> '; -         } the  * Response.Write (data); $ Response.End ();Panax Notoginseng  -     }); the }); +  AServer.listen (8080); the  + varSYS = require (' Util '); -Sys.puts (' Server running at http://localhost:8080/');

MySQL Query of Nodejs