MySQL ERROR 1136 (21S01)错误[疑难归档]

ERROR 1136 (21S01): Column count doesn't match value count at row n

一般这个问题是由于SQL语句中前面列的数目与后面的值的数目不一致造成的，如insert语句VALUES中的值的数目一定要跟前面选定的列的数目一致；如果是默认的选中全部的列，则要列出所有列需insert的值。

Reference URI:https://ubuntu-sky.blogspot.com/2009/02/mysql-error-1136-21s01.html

Have not found what you want?？ Try to search by Google

Enter your search terms Submit search form

Quote URI
https://ubuntu-sky.blogspot.com/2009/02/mysql-error-1136-21s01.html

• 0 comments »