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)
Read More:
- A convenient method to count the total number of query results in MySQL
- Count the frequency of words in English documents
- Opencv does not define identifier cv_ CAP_ PROP_ FRAME_ COUNT
- Matlab delete row or col to delete the row or column of the matrix
- 1072 – Key column ‘xxx_id’ doesn’t exist in table
- urllib3 (1.26.4) or chardet (4.0.0) doesn‘t match a supported version!
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- error LNK2038: mismatch detected for ‘RuntimeLibrary’: value ‘MTd_StaticDebug’ doesn’t match value ‘
- Mysql reports an error Operand should contain 1 column(s)
- MySQL error operation should contain 1 column (s)
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- error: pathspec ‘feature_card‘ did not match any file(s) known to git
- Error: pathspec ‘origin / xxx’ did not match any file (s) known to GIT
- MySQL error code 1217 (ER_ROW_IS_REFERENCED): Cannot delete or update a parent row: a foreign key co
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- ParserError: Error tokenizing data. C error: EOF inside string starting at row 917
- Error 1146 (42s02): table ‘database name. Table name’ doesn’t exist ‘