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
Can you tell what are various ways to create an index?
In mysql, what is the default storage engine?
How do I rename a mysql database?
What is blob and clob?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
Can you tell the difference between $message and $$message?
What is a storage engine?
List the different types of normalization?
What is the innodb in mysql?
How do I change the max connections in mysql?
How to rename an existing column in a table?
What is the current root password of mysql?
What is the difference between having and where clause in mysql? Explain
What does mysql_fetch_assoc do?
What are the different tables present in MySQL?