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

What is the full form of mysql?

1012

How do you shutdown a mysql database?

1051

Can you tell few best practices to be followed for optimization in sql?

901

What does tinyint mean?

917

What is trigger in mysql with example?

920

Describe mysql transaction properties.

1023

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

917

What are the common mysql functions?

944

What are the differences between mysql vs sql server?

1056

What you can use regular expression for in mysql?

946

Can you tell the difference between ereg_replace() and eregi_replace()?

1037

How to Join tables on common columns.

1187

What are the purposes of using enum and set data types?

937

What is mysql optimization?

909

What are numeric data types?

995