How do you index just the first four bytes of the column?
Answers were Sorted based on User's Feedback
Answer / amith
ALTER TABLE customers ADD INDEX (business_name(4))
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / monika
alter table table_name add index(substr(column_name,1,4));
| Is This Answer Correct ? | 0 Yes | 0 No |
How triggers can be used in mysql?
How do I find mysql version in mysql workbench?
Write a query to count the number of rows of a table in mysql.
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
What is mysql default port number?
Is mysql server free?
what is database black box testing? : Mysql dba
How can a user get the current SQL version?
How do you create a table in mysql workbench?
What is mysql and why it is used?
How do I rename a table in mysql?
What is schema in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)