How do you index just the first four bytes of the column?
- 2 Answers
- 4431 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
What is mysql workbench used for?
How do you flush privileges?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
How to make a copy values from one column to another in mysql?
What are the differences between binary and varbinary?
Can I use mysql for free?
How do I create a new database in mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is the current version of mysql?
Why do we use views instead of tables?
What is blob storage?
How do I change a procedure in mysql?
Explain the different types of mysql joins.
How to upload a large file through phpmyadmin in mysql?
What is the difference between primary key and candidate key?
