mysql limit

var queryStr = `insert into messages(text, userid, roomname)

value (?, (select id from users where username = ? limit 1), ?)`;

1개만 찾는다

 

db.query(queryStr, params, function (err, results) {

callback(err, results);

});