How do you index just the first four bytes of the column?
- 2 Answers
- 4610 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 trigger in mysql?
How do I copy a table in mysql?
What is the difference between the primary and unique key in mysql?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
Is sql similar to mysql?
Where’s database data actually stored?
What is the latest mysql version?
How to include character strings in sql statements?
What is the default port number of mysql?
What is the query to display top 20 rows?
What is the difference between the LIKE and REGEXP operators?
How large can a mysql table be?
what is the difference between gui testing and database testing? : Mysql dba
How do you use auto increment?
How to get nth highest salary from table in a mysql?
