Because

Statement, the number of columns inserted is more or less than the number of columns in the table

Change the number of front and back columns to be equal

Read More:

• Mysql Script Error Code: 1136. Column count doesn’t match value count at row 1
• Solve ERROR 1136 (21S01) in Mysql: Column count doesn’t match value count at row 1
• ERROR 1261 (01000): Row 1 doesn‘t contain data for all columns
• ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7
• SQL Server Group sort de duplication row_ number() over ( PARTITION BY t1.col_ 2 ORDER BY 1 )
• Mybatis Add Datas error: ERROR: Field * doesn‘t have a default value
• [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
• [Solved] MySQL Error: Can‘t find record in ‘order_form‘
• Error 1406 (22001) in MySQL: data too long for column (Fixed)
• MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
• MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
• How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
• postgresql-Database query problem-ERROR: column “t.domainid“ must appear in the GROUP BY clause or be used in an a
• Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
• [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
• Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
• (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
• MySQL: Got error 139 from storage engine [How to Solve]