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
What is view in mysql?
How to convert dates to character strings?
How to update database permissions/privilages.
Is mysql a backend?
What is default schema in mysql?
Is mysql a dbms?
Can't connect mysql server on localhost?
How does mysql clustering work?
In which format data is stored in mysql database?
What is the return type of mysqli_query?
What is mysql shell?
What are the functions in mysql?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
What is mysql enterprise edition?
How we can create index in mysql?