【mysql】 解决 auto_increment 字段 Column count doesn't match value count at row 1

1, 表结构   man

+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+

 

2 ,解决方法 

  insert into man values (NULL,'来福');     或  insert into man values (1,'来福');

posted @ 2020-11-12 19:26  武卡卡  阅读(264)  评论(0编辑  收藏  举报