How do you index just the first four bytes of the column?
Answers were Sorted based on User's Feedback
Answer / amith
ALTER TABLE customers ADD INDEX (business_name(4))
|Is This Answer Correct ?||2 Yes||0 No|
Answer / monika
alter table table_name add index(substr(column_name,1,4));
|Is This Answer Correct ?||0 Yes||0 No|
How do I automate a backup in mysql?
What language is mysql written in?
What is auto increment in mysql?
What is the use of count function in mysql?
What is difference between microsoft sql and mysql?
How do you know the version of your mysql server?
What is prepare statement in mysql?
What storage engines are used in MySQL?
How to get a version of mysql?
How to get nth highest salary from table in a mysql?
What is A BI Ap;plication?
Can python connect to mysql?