How do you index just the first four bytes of the column?
- 2 Answers
- 4430 Views
- I also Faced
- E-Mail Answers
Answer Posted / monika
alter table table_name add index(substr(column_name,1,4));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is federated tables in mysql?
How to get a list of indexes of an existing table?
What is the difference between primary key and candidate key?
What is slow query log in mysql?
How do I find users in mysql?
What are procedures in mysql? Explain
What is the use of i-am-a-dummy flag in mysql?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
Can we use mysql and mysqli together?
What is mysql workbench used for?
Is mysql a scripting language?
What is the difference between mysql and oracle?
What are the 'mysql' command line options?
How to Set a root password if there is on root password.
What does schema mean?
