Mysql date equal
Mysql date equal returns you the records from the table on the basis of date
condition specified in where clause.
Understand with Example
The Tutorial elaborate an example that helps you to understand Mysql date
equal. To understand it, we create a table 'Employees'. The create table
statement is used to create a table employee with field name and data type
respective.
Query:-
mysql> CREATE TABLE employees(
-> Empid int(10),
-> Empname varchar(60),
-> date date ); |
Output:-
Query:-
The insert into add the records or rows to the
table 'Employee'.
mysql> insert into employees (Empid,Empname,date)values('01','Girish','2008-12-22');
mysql> insert into employees (Empid,Empname,date)values('02','Komal','2008-12-23');
|
Output:-
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.02 sec) |
Query:-
The select show you the records from employees table.
| mysql> select * from employees; |
Output:-
+-------+---------+------------+
| Empid | Empname | date |
+-------+---------+------------+
| 1
| Girish | 2008-12-22 |
| 2
| Komal | 2008-12-23 |
+-------+---------+------------+
2 rows in set (0.00 sec) |
Query:-
The below Query show you only those records from
employee table as condition specified in where clause. In this Query this
show you the records from a table 'Employee' based on the date '2008-12-22'
condition in where clause.
| mysql> select * from employees where date like '2008-12-22'; |
Output:-
+-------+---------+------------+
| Empid | Empname | date |
+-------+---------+------------+
| 1
| Girish | 2008-12-22 |
+-------+---------+------------+
1 row in set (0.00 sec) |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
