var convID = 2525;
var contactUsername = 'blabla';
var userId = 100;
var contactId = 200;
var sql = "INSERT INTO contacts (FK_OWNERID, FK_USERID, FC_CONTACTNAME, `CONVERSATION_ID`)
VALUES (" + mysql.escape(userId) + "," + mysql.escape(contactId) + "," + mysql.escape(contactUsername) + "," + convID + "),
(" + mysql.escape(contactId) + "," + mysql.escape(userId) + "," + mysql.escape(username) + "," + convID + ")";
错误:ER_BAD_FIELD_ERROR:“字段列表”中的未知列“ 2525”对于CONVERSATION_ID和FC_CONTACTNAME而言,字段均为varchar(32),对于其他2个字段均为int。
这个查询怎么了?我什至放回了句号CONVERSATION_ID
,它认为convID
变量是一列...
编辑:
如果我的查询就是这样,那就可以了:
var sql = "INSERT INTO contacts (`FK_OWNERID`, `FK_USERID`, `FC_CONTACTNAME`)
VALUES (" + mysql.escape(userId) + "," + mysql.escape(contactId) + "," + mysql.escape(contactUsername) + "),
(" + mysql.escape(contactId) + "," + mysql.escape(userId) + "," + mysql.escape(username) + ")";
使
" + convID + "
至
'" + convID + "'
最有可能是字符串,数据类型是varchar,因此您需要用单引号引起来。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句