1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / amith

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

Explain multi-version concurrency control in MySQL?

2 Answers  

What is 'mysqlimport'?

0 Answers  

What is regexp?

0 Answers  

What is orm in mysql?

0 Answers  

How to return query output in html format?

0 Answers  




The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers   Afixi, GE,

How many triggers are possible in mysql?

0 Answers  

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  

What is truncate in mysql?

0 Answers  

What is mysql used for?

0 Answers  

What is relational database in mysql?

0 Answers  

How to find the unique values if the value in the column is repeated?

0 Answers  

For more MySQL Interview Questions Click Here
Categories