ALTER TABLE customers ADD INDEX (business

How do you index just the first four bytes of the column?

Question Posted / amith

2 Answers
5138 Views
I also Faced
E-Mail Answers

Answer Posted / amith

ALTER TABLE customers ADD INDEX (business_name(4))

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is view in mysql?

961

How to convert dates to character strings?

1051

How to update database permissions/privilages.

952

Is mysql a backend?

915

What is default schema in mysql?

919

Is mysql a dbms?

865

Can't connect mysql server on localhost?

1047

How does mysql clustering work?

893

In which format data is stored in mysql database?

984

What is the return type of mysqli_query?

847

What is mysql shell?

965

What are the functions in mysql?

924

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

872

What is mysql enterprise edition?

888

How we can create index in mysql?

957