求幫忙查找sql insert into語句錯誤?。。?/h1>
String sql=""+"insert into user_table (name,sex,keshi,jituanhao,group) values(?,?,?,?,?)";
提示：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 'group) values('ChenRenQiang','Man','CeShiYIShi',6915,'ShiJIngli')' at line 1.
SQL語句哪里出錯了？
String sql=""+"insert into user_table (name,sex,keshi,jituanhao,group) values(?,?,?,?,?)";
提示：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 'group) values('ChenRenQiang','Man','CeShiYIShi',6915,'ShiJIngli')' at line 1.
SQL語句哪里出錯了？
2015-07-28
為啥String sql前要加""+??？直接開始insert不行么？
2015-07-13
查到了，group是關鍵字，不能用做字段名。