|
bug:如果sql语句没有问题,nodejs又报错,就要检查数据库编码问题啦!
//我的报错代码:
Consigne:function (prompapi,s_province,s_city,s_county,xxdz,phones,yourname,callback) {
console.log(prompapi,s_province,s_city,s_county,xxdz,phones,yourname);
//参数:收货人,省,市,县,详细地址,电话号码,用户
//表:用户ID,具体地址,创建时间,是否删除,省,市,县,收货人,电话号码
let sql = 'insert into address (userID,Specificaddress,createTime,isdelete,province,city,county,consignee,telephoneNumber) value((select userID from user where userName = ?),?,"2018-7-13",0,?,?,?,?,?)';
db.connect(sql,[yourname,xxdz,s_province,s_city,s_county,prompapi,phones],callback);
},改正:在建库时创建编码
CREATE DATABASE `project` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; |
|