nodejs連接MySQL,首先安裝了mysql之后,在cmd界面安裝nodeJs的mysql模塊:
npm install mysql

mysql中創建數據庫“nodetry1”,再創建表table2:
指定id為主鍵:

var mysql = require('mysql');//選擇數據庫和表var TEST_DATABASE = 'nodetry1';var TEST_TABLE = 'table2';var connection = mysql.createConnection({ host: 'localhost', user: 'root', password: '123456'});//連接數據庫connection.connect();//選擇查詢的數據庫connection.query("use " + TEST_DATABASE);// 增加connection.query('insert into '+ TEST_TABLE +' (id,name,age) values (12, "二次添加會報錯" , 77)');// 刪除connection.query('delete from '+ TEST_TABLE +' where name = "sony"');// 修改connection.query('update '+ TEST_TABLE +' set name = "jiying.bao" where id = 5');//查詢connection.query('SELECT * from '+ TEST_TABLE , function(err, rows) { if(err) throw err; console.log("SELECT ==> "); for(var i in rows) { console.log(rows[i]); }});//關閉數據庫連接connection.end();運行js:

以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持武林網。
新聞熱點
疑難解答