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

Write a query to retrieve a hundred books starting from 20th.

1248

How do I run a query in mysql?

683

What is mysql cursor?

665

How do I insert multiple rows in a table?

632

What are the method you will follow while sql installing

2076

Restore database (or database table) from backup.

740

What is row level locking?

668

How to convert numeric values to character strings?

695

How do I use mysql?

653

What is dump in mysql?

633

Can you tell which of the following where clauses is faster?

623

What is the maximum number of columns per table?

660

What is mysql community edition?

690

What is the purpose of using timestamp data type?

667

What is the default password for mysql?

623