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 are numeric data types?
What is mysql port?
How to use 'mysql' to run sql statements?
What is mysql connection limit?
What is row level locking in mysql?
What is pdo in php mysql?
How would concatenate strings in mysql?
How do you rename a procedure in mysql?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What is inner join in mysql?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
How do I clear the screen in mysql?
How do I rename a table in mysql workbench?
How will show all records containing the name "sonia" and the phone number '9876543210'
What is ibdata1?