Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How do you index just the first four bytes of the column?

Answers were Sorted based on User's Feedback



How do you index just the first four bytes of the column?..

Answer / amith

ALTER TABLE customers ADD INDEX (business_name(4))

Is This Answer Correct ?    2 Yes 0 No

How do you index just the first four bytes of the column?..

Answer / monika

alter table table_name add index(substr(column_name,1,4));

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I automate a backup in mysql?

0 Answers  


What language is mysql written in?

0 Answers  


What is auto increment in mysql?

0 Answers  


What is the use of count function in mysql?

0 Answers  


What is difference between microsoft sql and mysql?

0 Answers  






How do you know the version of your mysql server?

0 Answers  


What is prepare statement in mysql?

0 Answers  


What storage engines are used in MySQL?

0 Answers  


How to get a version of mysql?

0 Answers  


How to get nth highest salary from table in a mysql?

0 Answers  


What is A BI Ap;plication?

1 Answers   HCL,


Can python connect to mysql?

0 Answers  






Categories