Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  

Why is mysql used?

0 Answers  

What is a csv table?

0 Answers  

Is there a free version of mysql?

0 Answers  

How do I use mysql?

0 Answers  

What is an example of a delimiter?

0 Answers  

What is the storage engine for mysql?

0 Answers  

What is a procedure example?

0 Answers  

using primary can we relate two table, with out foreign key?

0 Answers  

What language is used in mysql?

0 Answers  

What is mysql57?

0 Answers  

What is dump in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories