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

Can you tell what are various ways to create an index?

819

In mysql, what is the default storage engine?

934

How do I rename a mysql database?

893

What is blob and clob?

895

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1395

Can you tell the difference between $message and $$message?

911

What is a storage engine?

901

List the different types of normalization?

889

What is the innodb in mysql?

966

How do I change the max connections in mysql?

829

How to rename an existing column in a table?

984

What is the current root password of mysql?

861

What is the difference between having and where clause in mysql? Explain

955

What does mysql_fetch_assoc do?

911

What are the different tables present in MySQL?

1049