ERROR 1136 (21S01): Column count doesn't match value count at row 1
程序员文章站
2022-04-12 16:25:02
...
因为是刚刚开始学习数据库,所以今天在用mysql做练习的时候,一直在出一个问题:ERROR 1136 (21S01): Column count doesn’t match value count at row 1
在这里记录一下。
create table my_int(
int_1 tinyint,
int_2 smallint,
int_3 mediumint,
int_4 int,
int_5 bigint
)charset utf8;
insert into my_int values(10,100,10000,1000000,11111111111);
一开始先创建了5钟类型的数据,然后在往里面添加数据的时候一直没注意到原来输入的数和创建的数的个数不匹配。
解决后,数据存储成功!
上一篇: C语言指针地址与数字、字符串的转换
下一篇: Caused by: org.hibernate.AnnotationException: No identifier specified for entity:
推荐阅读
-
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
-
Column count doesn't match value_PHP教程
-
Column count doesn't match value
-
注å页é¢åºç°Column count doesn't match value count at row 1
-
注å页é¢åºç°Column count doesn't match value count at row 1
-
SQL报错:Column count doesn't match value count at row 1
-
ERROR 1136 (21S01): Column count doesn't match value count at row 1