nodejs mysql

最新推荐文章于 2025-12-10 22:18:24 发布

原创最新推荐文章于 2025-12-10 22:18:24 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #table #mysql #insert #function #callback

Javascript类专栏收录该内容

112 篇文章

订阅专栏

安装

npm install mysql

实例

http://www.neekey.net/wiki/doku.php?id=nodejs:nodejs%E4%B8%8Emysql

下面以ubuntu下为例

安装mysql module
```
 $ npm install mysql
```
新建一个文件 mysql.js

输入如下内容

var Client = require('mysql').Client,  
    client = new Client();
 
client.password = 'helloworld';
client.user = 'root';
 
var DATABASE_NAME = 'neekey_database',
TABLE_NAME = 'neekey_table';
 
console.log(client.connect());
 
client.query('CREATE DATABASE '+ DATABASE_NAME, function(err) { 
  if (err && err.number != Client.ERROR_DB_CREATE_EXISTS) {  
 
  console.log(err);
    throw err;  
  }  
});  
// If no callback is provided, any errors will be emitted as `'error'`  
// events by the client  
client.query('USE '+ DATABASE_NAME);  
client.query(  
  'CREATE TABLE '+ TABLE_NAME +  
  '(id INT(11) AUTO_INCREMENT, '+  
  'title VARCHAR(255), '+  
  'text TEXT, '+  
  'created DATETIME, '+  
  'PRIMARY KEY (id))'  
);  
 
client.query(  
  'INSERT INTO '+ TABLE_NAME +' '+  
  'SET title = ?, text = ?, created = ?',  
  ['super cool', 'this is a nice text', '2010-08-16 10:00:23']  
);  
 
var query = client.query(  
  'INSERT INTO '+ TABLE_NAME +' '+  
  'SET title = ?, text = ?, created = ?',  
  ['another entry', 'because 2 entries make a better test', '2010-08-16 12:42:15']  
);  
 
client.query(  
  'SELECT * FROM '+ TABLE_NAME,  
  function selectCb(err, results, fields) {  
    if (err) {  
      throw err;  
    }  
 
    console.log(results);  
    console.log(fields);  
    client.end();  
  }  
);