|
|
|
|
|
|
by qqshfox
4882 days ago
|
|
|
> For comparisons of a string column with a number, MySQL cannot use an index on the column to look up the value quickly. If str_col is an indexed string column, the index cannot be used when performing the lookup in the following statement: > SELECT * FROM tbl_name WHERE str_col=1; add index please |
|
|