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

How do I check mysql version?

484

What sql does mysql use?

481

What does it mean to be case sensitive?

466

How to enter microseconds in sql statements?

513

What is row locking in mysql?

499

What is a simple query?

459

Explain what is mysql?

577

What data type is money?

459

What is the use of mysql_close()?

506

Why should I learn mysql?

478

Is mysql a framework?

479

How do I edit a stored procedure in mysql?

489

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

481

What is a query in mysql?

472

Why we use mongodb instead of mysql?

474