Question

mysql插入语句报错,麻烦大神帮忙看一下

insert into user_association_jk (card_no) values(?) where admin_Id=?
在编写SQL时如上编写, 执行时报如下异常,请问这是什么问题吗?谢谢~

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where admin_Id='15210159266'' at line 1

Answer 1

everyone agrees插入语，随便放前面放后面翻译都行；it形式主语，真的主语是that后面的child performs when he learns to speak ，也就是说这句话可以变成everyone agrees，child performs when he learns to speak is a huge task 后面一句断开翻译就好啦，the fact that he does so in so short a period time challenges explanation。顶挑战的翻译。

Answer 2

你用的是PreparedStatement吧（如果是JAVA），建议把整个的sql语句，没有？这种形式的先试一下，看是不是where前面没有空格，还是引号没用对，还是value的数据类型不对，弄对了之后再用PreparedStatement写