The problem is that when a new row is inserted, an error is returned.
type:
mysql> insert into students values(1,"goutou",18,"male",12121);
Returns:
ERROR 1136 (21S01): Column count doesn't match value count at row 1
check statement is ok. Considering the previous operation of deleting a column, two new columns are added, and the input is:
mysql> insert into students(id,name,age,gender,clc_id) values(0,"zhutou",12,"male",12121);
Query OK, 1 row affected (0.06 sec)
Read More:
- Mysql Script Error Code: 1136. Column count doesn’t match value count at row 1
- [Solved] Mysql Error: [Err] 1136 – Column count doesn‘t match value count at row 1
- ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- ERROR 1261 (01000): Row 1 doesn‘t contain data for all columns
- [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
- Error 1406 (22001) in MySQL: data too long for column (Fixed)
- [Solved]Error 1054 (42s22): unknown column ‘password’ in ‘field list’ how to modify the password
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- How to Solve “Out of range value for column” Error
- How to Solve mysql [Err] 1067-Invalid default value for
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘