win7上的node.js与mysql交互
win7下的node.js与mysql交互安装mysql模块的命令：npm install mysql然后建立mysqlTest.js：client.host
win7下的node.js与mysql交互
安装mysql模块的命令：
npm install mysql
然后建立mysqlTest.js：
client.host = '127.0.0.1';client.port = 3306;
这里不能把host写成localhost，不然一样会抛出err错误。
嘿嘿，问题解决了，是不是该给笔者一个好评，谢谢
运行结果：
$ node /example/mysql/mysqltest.js
over-------------------------
shenyuc629-----null
[ { id: 1,
title: 'super cool',
text: 'this is a nice text',
created: Mon, 16 Aug 2010 10:00:23 GMT },
{ id: 2,
title: 'another entry',
text: 'because 2 entries make a better test',
created: Mon, 16 Aug 2010 12:42:15 GMT } ]
{ id:
{ length: 51,
received: 51,
number: 2,
type: 4,
catalog: 'def',
db: 'nodejs_mysql_test',
table: 'test',
originalTable: 'test',
name: 'id',
originalName: 'id',
charsetNumber: 63,
fieldLength: 11,
fieldType: 3,
flags: 16899,
decimals: 0 },
title:
{ length: 57,
received: 57,
number: 3,
type: 4,
catalog: 'def',
db: 'nodejs_mysql_test',
table: 'test',
originalTable: 'test',
name: 'title',
originalName: 'title',
charsetNumber: 192,
fieldLength: 765,
fieldType: 253,
flags: 0,
decimals: 0 },
text:
{ length: 55,
received: 55,
number: 4,
type: 4,
catalog: 'def',
db: 'nodejs_mysql_test',
table: 'test',
originalTable: 'test',
name: 'text',
originalName: 'text',
charsetNumber: 192,
fieldLength: 196605,
fieldType: 252,
flags: 16,
decimals: 0 },
created:
{ length: 61,
received: 61,
number: 5,
type: 4,
catalog: 'def',
db: 'nodejs_mysql_test',
table: 'test',
originalTable: 'test',
name: 'created',
originalName: 'created',
charsetNumber: 63,
fieldLength: 19,
fieldType: 12,
flags: 128,
decimals: 0 } }
1 楼 witcheryne 前天 建议不要折腾node.js + 关系型数据库这块. 有点浪费时间. 2 楼 shenyuc629 昨天 一楼，我是知道什么数据库，首先测试什么数据库
