Mysql Date Search
In this Tutorial you will learn how to' search Date in Mysql'. To understand
this example, we create a table 'employee' with required fieldname and datatype
respectively. The Table employee has a 'empid' as Primary Key. The keyword create
table employee is used to create a table 'employee'.
Create table "employee":
CREATE TABLE `employee` (
`id` bigint(20) NOT NULL auto_increment,
`emp_name` varchar(100) NOT NULL,
`emp_dob` date default NULL,
PRIMARY KEY (`id`)
) |
Query to insert the record in the table "employee":
Now the Query insert into is used to add the records or rows
into table 'employee'
insert into employee (emp_name,emp_dob)values('Sourabh','1985-11-07');
insert into employee (emp_name,emp_dob)values('Vineet','1983-11-07');
insert into employee (emp_name,emp_dob)values('Girish','1984-10-06');
insert into employee (emp_name,emp_dob)values('Sourabh','1982-01-05'); |
Query to retrieve the records from table "employee":
To view the details of the records from table 'employee' we run
select query to retrieve it.
Output:
mysql> select * from employee
+----+----------+------------
| id | emp_name | emp_dob
+----+----------+------------
| 1 | Sourabh | 1985-11-07
| 2 | Vineet | 1983-11-07
| 3 | Girish | 1984-10-06
| 4 | Sourabh | 1982-01-05
+----+----------+------------
4 rows in set (0.00 sec)
|
Query to Search record by Date:
The Query below returns the records details from table
employee whose emp_dob is '1985-11-07'.
| select * from employee where emp_dob='1985-11-07' |
Output :
+----+----------+------------+
| id | emp_name | emp_dob |
+----+----------+------------+
| 1 | Sourabh | 1985-11-07 |
+----+----------+------------+ |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
