1. Explain the ref field in the Explain information
Indicates which column of the index is used, if possible, as a constant. Which columns or constants are used to find values on indexed columns
2. Explain the ref field in the information
From key_len we can see that IDX_COL1_COL2 of table T1 is fully used, that col1 matches col1 of table T2, and that col2 matches a constant, that is, the fields associated with other tables in the ‘AC’ query, and that the foreign key relationship is indexed
Read More:
- MySql ERROR CODE：1215 Cannot add the foreign key constraint
- MySQL failed to add foreign key: SQL 1452 cannot add or update a child row:a foreign key constraint fails
- MySQL error: can’t create table ‘..’（ errno:150 ）Solutions
- SQL Union, union all usage and common errors and Solutions
- MySQL error 1451 23000 foreign key exception handling
- E11000 duplicate key error collection in mongodb
- Some mistakes and solutions in Django
- On set in pandas_ Index and reset_ Usage of index
- Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
- Ora-00947: not enough values
- About MySQL error: subquery returns more than 1 row
- MySQL error: column ‘ID’ in field list is ambiguous
- Ctfhub error injection
- MySQL partitions the existing tables of the data table
- Pandas get column name
- DB2 table annotation pull
- MySQL:Foreign key fails with error Error Code: 1452.
- 1822 – Failed to add the foreign key constraint. Missing index for constraint ‘tb_emp_ibfk_1’ in the
- mysql Error Code: 1022. Can’t write; duplicate key in table `xxx`
- R note for Bioinfo: the column for the select call is undefined