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  

---

How do I start mysql client?

0 Answers  

---

How important is to list the column names when doing an insert?

0 Answers  

---

How many columns is too many mysql?

0 Answers  

---

What are the 3 main types of search queries?

0 Answers  

---

What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  

---

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

How to see table's field formats or description of table .

0 Answers  

---

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  

---

What is the innodb in mysql?

0 Answers  

---

How to get a version of mysql?

0 Answers  

---

In how many ways we can retrieve data in the result set of mysql using php?

0 Answers  

---