Answer / amith

ALTER TABLE customers ADD INDEX (business_name(4))

Answer / monika

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

How many rows can be inserted in mysql at a time?

0 Answers  

---

is it possible to assign two primary key in a table

8 Answers   IBM,

---

What is the use of mysqli_num_rows?

0 Answers  

---

How to show all tables with 'mysql'?

0 Answers  

---

What sql does mysql use?

0 Answers  

---

---

What are mysql data types?

0 Answers  

---

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1 Answers  

---

How to use triggers to track changes in mysql?

0 Answers  

---

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  

---

Why is mysql popular?

0 Answers  

---

How to update a root password.

0 Answers  

---

Is mysql a dbms?

0 Answers  

---