代码改变世界

nodejs 对mysql操作查询

2013-12-17 11:38  freefei  阅读(312)  评论(0)    收藏  举报

mysql.query("select * from ci_sessions where session_id=? limit 1", [data.sessid], login_callback);

 

1 mysql.query方法 参数问号问题?

 

官方找到答案

Alternatively, you can use ? characters as placeholders for values you would like to have escaped like this:

connection.query('SELECT * FROM users WHERE id = ?', [userId], function(err, results) {
  // ...
}); 
你可已用?做为站位符合 后面的参数表示值 是在是新鲜
@ https://github.com/ranmufei Pop Balloons Game - Free Online Stress Relief Game