Answer / shashikant

distinct <column name>
from <table name>

Answer / balaji

alter ignore table <tablename> add unique key
(field1,field2,....);

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers  

---

What is mysql in dbms?

0 Answers  

---

What are the features of mysql?

0 Answers  

---

Write a query to stop mysql in unix

0 Answers  

---

What is bigint in mysql?

0 Answers  

---

---

How do I change the max connection in mysql?

0 Answers  

---

What is the datatype of image in mysql?

0 Answers  

---

How to include character strings in sql statements?

0 Answers  

---

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

---

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  

---

What is mysql and mysqli?

0 Answers  

---

What is 'mysqladmin' in mysql?

0 Answers  

---