How do you index just the first four bytes of the column?
Answer Posted / monika
alter table table_name add index(substr(column_name,1,4));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is mysql57?
How to include character strings in sql statements?
What is mysql slow query?
What is difference between function and procedure in mysql?
How to set mysql variable in php?
What is the difference between is null & is not null?
What is mysqli_select_db?
What does schema mean?
What is the purpose of using ifnull() function?
How do I insert multiple rows in a table?
What is difference between mysql and mysqli?
What are enums used for in mysql?
How can you make a database as your current database?
How do I disconnect mysql workbench?
How do I view data in mysql workbench?