Unknown column 'a' in 'field list'int i=1;String str="qinyue";String ss="insert into liuyansf(userid,username)values("+i+","+str+")";为什么 i=1 就可以 顺利的显示在数据库中而str=“qinyue" 就不行哦,就会出现Unknown column 'qiny

来源：学生作业帮助网 编辑：作业帮 时间：2024/04/30 13:33:23

Unknown column 'a' in 'field list'int i=1;String str="qinyue";String ss="insert into liuyansf(userid,username)values("+i+","+str+")";为什么 i=1 就可以 顺利的显示在数据库中而str=“qinyue" 就不行哦,就会出现Unknown column 'qiny
Unknown column 'a' in 'field list'
int i=1;
String str="qinyue";
String ss="insert into liuyansf(userid,username)values("+i+","+str+")";
为什么 i=1 就可以 顺利的显示在数据库中
而str=“qinyue" 就不行哦,就会出现Unknown column 'qinyue' in 'field list' 错误
数据库中 i 是int 类型,str 是text 类型哦
我用的是JSP+MYSQL

Unknown column 'a' in 'field list'int i=1;String str="qinyue";String ss="insert into liuyansf(userid,username)values("+i+","+str+")";为什么 i=1 就可以 顺利的显示在数据库中而str=“qinyue" 就不行哦,就会出现Unknown column 'qiny
String ss="insert into liuyansf(userid,username)values("+i+","+str+")";
数据库的字符串要用引号区分的
这样改试试
不行的话再百度HI联系我
String ss="insert into liuyansf(userid,username)values("+i+",'"+str+"')";
分别在,和)这个括号前加一个单引号

Unknown column 'a' in 'field list'int i=1;String str=qinyue;String ss=insert into liuyansf(userid,username)values(+i+,+str+);为什么 i=1 就可以 顺利的显示在数据库中而str=“qinyue 就不行哦,就会出现Unknown column 'qiny Unknown column 'md5pass' in 'field list' I. Match the words in column A with the appropriate definitions in column B. （30’ ) a column of a column of unknown PHP连接数据库碰到问题.Cannot query the database.Unknown column 'event_name' in 'field list' com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Unknown column '999_Apronsotoldersowels.jpg' in 'field list'这是什么原因? COLUMN I will never believe a boy who is unknown for me. OFFSET COLUMN OFFSET($A$1,COLUMN()-2,为什么在row的位置填column? Unknown column '何宇' in 'field list'jsp连接数据库时出现错误,具体内容如上, ___ is unknown to others but you that I'll change another job.A what B It EXcel公式套用问题：=IF(ISERROR(VLOOKUP($C5,数据表!$A$2:$I$2712,COLUMN()-2,0)),,VLOOKUP($C5,数据表!$A$2:$I$2712,COLUMN()-2,0))这个公式怎麼套用到别个表格裏面 英语作业谁帮忙做哦?Part I Vocabulary（5 points）从B列中选择相应的解释,将其选项填入A列单词对应的空格里.Column A Column B___1___ merit A scholarly___2___ track B 这个句子中,过去分词短语做什么成分?One day a card that I sent came back stamped “Address Unknown”.在这个句子中,stamped “Address Unknown”做什么成分? “未知的旅途”翻译：an unknown journey还是a journey unknown比较好?用作签名, 在MySQL中出现Unknown column 'abc' in 'field list'怎么解决?在添加表格内容中 该用哪种单引号啊?