Mysql date equal returns you the records from the table on the basis of date condition specified in where clause.

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)

Related Tags for Mysql date equal:
sql,  mysql,  date,  help,  tutorial,  ria,  example,  to,  exam,  e,  sta,  m,  ps,  rate,  equal,  tor,  xa,  xamp,  s,  at,  my,  ha,  mpl,  and,  tutor,  s,  s,  ri,  th,  st,  ab,  hat,  ple,  pl,  nd,  o

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date