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 are the disadvantages of mysql?

0 Answers  

---

What is InnoDB?

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 do you rename a table?

0 Answers  

---

---

What is the difference between float and double?

0 Answers  

---

What is difference between group by and order by clause?

0 Answers  

---

What is the difference between a heap table and temporary table?

0 Answers  

---

Why do we use views instead of tables?

0 Answers  

---

How do I quit mysql?

0 Answers  

---

Does mysql use sql?

0 Answers  

---

What is int unsigned?

0 Answers  

---