alter table table_name add index(substr(column

How do you index just the first four bytes of the column?

Question Posted / monika

Answer Posted / monika

alter table table_name add index(substr(column_name,1,4));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens if null values are involved in expressions?

973

How can you move the master database

1968

Why is mysql used?

879

How do I install the latest mysql on ubuntu?

918

Is mysql a database?

877

Difference between CHAR and VARCHAR?

1020

How can you export the table as an xml file in mysql?

839

What is dirty read and phantom read?

821

What are the advantages of mysql in comparison to oracle?

967

What port is mysql running on?

871

Explain Access Control Lists.

929

What are the steps required to view your mysql database?

1033

What is the difference between a database and a table?

949

What does schema mean?

874

What is the latest mysql version?

925