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
Restore database (or database table) from backup.
Where is mysql used?
How to declare variable in mysql trigger?
Tell us something about heap tables?
What is mysql architecture?
How to convert dates to character strings?
What is mysql shell?
Can python connect to mysql?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What is the difference between procedure and function in mysql?
What is the maximum number of records in mysql table?
What is mysqli_select_db?
What is a user defined variable?
Is postgresql better than mysql?
How do I truncate all tables in mysql?