把Mysql Module裝到NodeJS中

Js代碼

復(fù)制代碼 代碼如下:

$npm install Mysql

復(fù)制代碼 代碼如下:

// mysqlTest.js
//加載mysql Module
var Client = require('mysql').Client,
client = new Client(),
　　
　 //要?jiǎng)?chuàng)建的數(shù)據(jù)庫(kù)名
TEST_DATABASE = 'nodejs_mysql_test',
//要?jiǎng)?chuàng)建的表名
TEST_TABLE = 'test';

//用戶名
client.user = 'root';
//密碼
client.password = 'root';
//創(chuàng)建連接
client.connect();

client.query('CREATE DATABASE '+TEST_DATABASE, function(err) {
if (err && err.number != Client.ERROR_DB_CREATE_EXISTS) {
throw err;
}
});

// If no callback is provided, any errors will be emitted as `'error'`
// events by the client
client.query('USE '+TEST_DATABASE);
client.query(
'CREATE TABLE '+TEST_TABLE+
'(id INT(11) AUTO_INCREMENT, '+
'title VARCHAR(255), '+
'text TEXT, '+
'created DATETIME, '+
'PRIMARY KEY (id))'
);

client.query(
'INSERT INTO '+TEST_TABLE+' '+
'SET '+
'SET src="http://www.survivalescaperooms.com/uploads/allimg/130820/14301QN8_0.gif?201371810194">