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

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

How much does mysql cost?

475


How to get help information from the server?

540


What is row locking in mysql?

499


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

496


What is mysql_query?

448






What is the maximum size of table in mysql?

550


What is difference between mysql mysqli and pdo?

465


How to write after insert event update trigger on the same table in mysql?

494


how can you test for null values in a database? : Mysql dba

465


How to upload a large file through phpmyadmin in mysql?

422


Which mysql function is used to concatenate string?

761


What do you understand by mysql terminal?

507


can you elaborate on blob and text in mysql? : Mysql dba

467


What is a longblob?

495


What are aggregate functions in mysql?

661