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 ISAM?

1115

Explain triggers and stored procedures?

928

How triggers can be used in mysql?

1017

How to delete a database from mysql server.

1068

What are the advantages of myisam over innodb?

987

Where is mysql data stored linux?

1019

How can I create a database in mysql?

867

Why do we use preparedstatement?

929

What is memory table in mysql?

945

What is the phantom problem?

1003

What is limit in mysql?

870

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1024

What is myisam?

972

How can I create database in mysql?

927

What is required to create mysql database?

987