exports.get_onwer_club_count = function (userId, callback) {
console.log("get_onwer_club_count");
callback = callback == null ? nop : callback;
var sql = 'SELECT COUNT(id) FROM club WHERE club.clubowner = ' + userId + ';'
query(sql, function (err, rows, fields) {
if (err) {
callback(null);
throw err;
} else {
callback(rows[0]['COUNT(id)']);
}
})
};
Nodejs 读取mysql 数据,要取数据条数 'COUNT(id)' 或者 ‘COUNT(*)'
如代码中,rows[0]['keyName'],直接读取就可以