7104880
node:0.6.17
mysql:5.5.21
os:lion 10.7.3
var
//sys = require('sys'),
mysql = require('/Users/mackjoner/tech/nodejs/node_modules/mysql-libmysqlclient'),
conn,
result,
row,
rows;
var
host = "localhost",
user = "test",
password = "password",
database = "db",
test_table = "users";
conn = mysql.createConnectionSync();
conn.connectSync(host, user, password, database);
//sys.puts("Information:");
//sys.puts(sys.inspect(conn.getInfoSync()) + "\n");
if (!conn.connectedSync()) {
//sys.puts("Connection error " + conn.connectErrno + ": " + conn.connectError);
console.log("Connection error " + conn.connectErrno + ": " + conn.connectError);
process.exit(1);
}
conn.query("SELECT * FROM " + test_table + ";", function (err, res) {
if (err) {
throw err;
}
res.fetchAll(function (err, rows) {
if (err) {
throw err;
}
//sys.puts("Rows in table '" + database + "." + test_table + "':");
//sys.puts(sys.inspect(rows));
console.log("Rows in table '" + database + "." + test_table + "':");
// This isn't necessary since v1.2.0
// See https://github.com/Sannis/node-mysql-libmysqlclient/issues#issue/60
//res.freeSync();
});
});
process.on('exit', function () {
conn.closeSync();
});
提示信息
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from: /Users/yangzhaojie/tech/nodejs/node_modules/mysql-libmysqlclient/build/Release/mysql_bindings.node
Expected in: flat namespace
dyld: Symbol not found: _mysql_init
Referenced from: /Users/yangzhaojie/tech/nodejs/node_modules/mysql-libmysqlclient/build/Release/mysql_bindings.node
Expected in: flat namespace