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: column ‘ID’ in field list is ambiguous
- Detailed explanation of yield in Python — the simplest and clearest explanation
- Explain MySQL replication error 1032 & 1205
- mysql error 1033 Incorrect information in file: ‘xxx.frm’ (Fixed)
- Solution of duplicate entry ‘value’ for key ‘field name’ in MySQL
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’
- Nginx error log (error_ Log) configuration and information explanation
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- MySQL unknown column ‘in’ field list ‘solution
- Cause: java.sql.BatchUpdateException: Unknown column ‘xxx‘ in ‘field list‘
- MySQL ERROR 1054 (42S22): Unknown column’password’ in’field list’ error
- Use xx [‘xx ‘] = XX to set field value or does not support field: XXX
- Explain stdin, stdout, stderr in C language
- New fields in hive table and modification of field comments
- MySQL error: 1005 can’t create table (error: 150)
- Explanation of port mapping in dlink
- Advanced parameter search of GitHub
- Windowserror: [error 183] error and in Python os.raname () detailed explanation
- Explanation of the function strip(), lstrip(), rstrip() in Python