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 is mysql57?

894

How to include character strings in sql statements?

956

What is mysql slow query?

931

What is difference between function and procedure in mysql?

935

How to set mysql variable in php?

912

What is the difference between is null & is not null?

975

What is mysqli_select_db?

945

What does schema mean?

924

What is the purpose of using ifnull() function?

935

How do I insert multiple rows in a table?

877

What is difference between mysql and mysqli?

901

What are enums used for in mysql?

989

How can you make a database as your current database?

1017

How do I disconnect mysql workbench?

1039

How do I view data in mysql workbench?

996