MySql提示Column count doesn't match value count at row 1
来源:互联网 发布:mac 弹丸论破 言刃 编辑:程序博客网 时间:2024/06/05 02:58
转自:http://blog.163.com/yaxctgu@126/blog/static/1626703182010111444728673/
今天在将sql server语句改成MySQL语句时报错:Column count doesn't match value count at row 1,讲的是表的列数与你插入的数据列数不匹配。
commputerroom表总共五列,每列都不许为空,第一列为自增长的,现向该表中插入数据:INSERT INTO computerroom VALUES('ddd',9,12,108);
结果报错:[SQL] INSERT INTO computerroom VALUES('ddd',9,12,108);[Err] 1136 - Column count doesn't match value count at row 1
但是改成:INSERT INTO computerroom VALUES(3,'ddd',9,12,108);即把自增长列指定值,却又可以!这下把我给搞晕了,查看了表的结构也是自增长的啊,那是什么问题呢?后来回到最原始的写法,指定列名,INSERT INTO computerroom(name,rowscount,columnscount,total) VALUES('ddd',9,12,108);一执行,ok了,竟然成功了!把上面语句拿到sql server中去执行却是能够成功执行的!原来mysql 跟sql server在这个语句的处理上是有区别的!大家写的时候千万别忘了,免得再去为这个问题而纠结!
- 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
- 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
- UITableViewCell复用机制
- VB老鸟初学Python(Python for kids)实例篇
- Android代码混淆工具Proguard学习
- HDC3461Code Lock(并查集)
- zookeeper集群配置学习随笔
- MySql提示Column count doesn't match value count at row 1
- OS X 中 brew 安装 php
- 如何使用Ubuntu SDK中的Download Manager来下载文件
- 李开复写给中国大学生的第七封信
- 关于 oracle profile 的知识点
- BZOJ 4052 Cerc2013 Magical GCD
- jmx远程连接weblogic
- [shell]tomcat项目的发包
- SEO之title优化