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

Restore database (or database table) from backup.

1071

Where is mysql used?

1033

How to declare variable in mysql trigger?

1067

Tell us something about heap tables?

1046

What is mysql architecture?

1071

How to convert dates to character strings?

1134

What is mysql shell?

1039

Can python connect to mysql?

1091

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

974

What is the difference between procedure and function in mysql?

1073

What is the maximum number of records in mysql table?

975

What is mysqli_select_db?

1013

What is a user defined variable?

956

Is postgresql better than mysql?

1072

How do I truncate all tables in mysql?

1039