ALTER TABLE customers ADD INDEX (business

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

Question Posted / amith

Answer Posted / amith

ALTER TABLE customers ADD INDEX (business_name(4))

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does mysql use sql?

946

What is mysql default port number?

1054

How to delete a column and add a new column to database

994

What do ddl, dml, and dcl stand for?

964

What is difference between mysql mysqli and pdo?

1030

What is a procedure example?

984

How do I install the latest mysql on ubuntu?

1036

What is mysqli_select_db?

1013

How set mysql root password?

966

What does mysql_fetch_assoc do?

997

What is max connection in mysql?

986

What is dbms in mysql?

1013

How to load data files into tables with 'mysqlimport'?

1037

In which format data is stored in mysql database?

1049

How do you insert a table?

971