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
Does mysql use sql?
What is mysql default port number?
How to delete a column and add a new column to database
What do ddl, dml, and dcl stand for?
What is difference between mysql mysqli and pdo?
What is a procedure example?
How do I install the latest mysql on ubuntu?
What is mysqli_select_db?
How set mysql root password?
What does mysql_fetch_assoc do?
What is max connection in mysql?
What is dbms in mysql?
How to load data files into tables with 'mysqlimport'?
In which format data is stored in mysql database?
How do you insert a table?