Mysql报错:Column count doesn't match value count at row 1
来源:互联网 发布:手机淘宝申请售后不了 编辑:程序博客网 时间:2024/05/18 18:00
在MyEclipse上执行mysql的插入语句时,一直报错:Column count doesn't match value count at row 1。
折腾了好几个小时后,终于找到原因了!
原始sql语句:
INSERT INTO users VALUES('u1','小明','u1','男','13877985456','424435','10000@qq.com','湖南长沙');
首先,不是列的数量和值的数量不一致的错误,第一个排除了。
其次,查找sql语句的严谨性,看百度上有人说mysql容错能力不强,不识别单引号,先后在语句的values中更换了双引号、反单引号,依然出错,郁闷。
最后,只能按照规则手写一遍,居然成功了!原来是没有加上字段名!!!!尼玛!
修改后sql语句:
INSERT INTO users(ulogin,uname,upass,usex,uphone,upost,uemail,uaddress) VALUES('u1','小明','u1','男','13877985456','424435','10000@qq.com','湖南长沙');
分析:
原始sql语句不是错误的,它仅适用于SQL server数据库。
而修改后的sql语句才适合mysql数据库。
0 0
- Mysql报错:Column count doesn't match value count at row 1
- MySQL报错: java.sql.SQLException: Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- Column count doesn't match value count at row 1
- mysql错误:Column count doesn't match value count at row 1
- mysql提示Column count doesn't match value count at row 1错误
- 执行Mysql提示"Column count doesn't match value count at row 1"错误
- mysql提示Column count doesn't match value count at row 1错误
- mySql中:Column count doesn't match value count at row 1
- MySql提示Column count doesn't match value count at row 1
- 【MySql】Column count doesn't match value count at row 1 解决方法
- hdu 4770 状态压缩模拟
- 关于uva10123
- 我之见--java多线程 ConcurrentHashMap 源码分析
- SVD分词分类的思考
- HDU 3061 最大权闭合图
- Mysql报错:Column count doesn't match value count at row 1
- Java高新技术:反射
- Android之内存管理
- Notepad++使用心得和特色功能介绍
- Lifting the Stone(求任意多边形的重心)
- 【Qt for Android】第一个安卓程序
- “System.Web.UI.Page”不包含“DataItem”的定义,问题的解决
- Hadoop V2.0.3 Cluster Setup Guide
- Python(2.7.x)启动浏览器