mysql select statement after index

Arrogant Ape answered on September 7, 2020 Popularity 7/10 Helpfulness 4/10

answer mysql select statement after index

Comment

   SELECT * FROM table1 USE INDEX (col1_index,col2_index)
    WHERE col1=1 AND col2=2 AND col3=3;

Popularity 7/10 Helpfulness 4/10 Language sql

Tags: mysql select sql

Link to this answer
Share Copy Link

Contributed on Sep 07 2020

Arrogant Ape

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.