After creating the library, I inserted the data into ERROR “ERROR 1136 (21S01): Column count doesn’t match value Count at row 1”. At the beginning, I thought it was a data type ERROR. Then DESC looked at it and found that it was char (10).
You can see that the unknown column is displayed, which is obviously an SQL statement error, and then you can look at my statement and see that the quotes are missing (manual face-covering).
Mysql> insert into student values(ka,18);
ERROR 1054 (42S22): Unknown column ‘ka’ in ‘field list’
Mysql> insert into student values(‘saoka’,’18’);
Query OK, 1 row affected (0.01 SEC)
You can see that the unknown column is displayed, which is obviously an SQL statement error, and then you can look at my statement and see that the quotes are missing (manual face-covering).
Mysql> insert into student values(ka,18);
ERROR 1054 (42S22): Unknown column ‘ka’ in ‘field list’
Mysql> insert into student values(‘saoka’,’18’);
Query OK, 1 row affected (0.01 SEC)