Defining Set Membership:Finding Records in a Set : Date Type « Date Time « SQL / MySQL






Defining Set Membership:Finding Records in a Set

  
/*
mysql> SELECT ExamID, SustainedOn, Comments FROM Exam
    -> WHERE ExamID IN (2, 7, 3);
+--------+-------------+-----------------+
| ExamID | SustainedOn | Comments        |
+--------+-------------+-----------------+
|      2 | 2004-03-13  | C# test         |
|      3 | 2005-03-11  | JavaScript Test |
+--------+-------------+-----------------+
2 rows in set (0.00 sec)


*/

/* Prepare the data */ 
DROP TABLE Exam;

CREATE TABLE Exam (
   ExamID      INT NOT NULL PRIMARY KEY,
   SustainedOn DATE,
   Comments    VARCHAR(255)

)TYPE = InnoDB;


/* Insert data for testing */ 
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (1,'2003-03-12','Java Test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (2,'2004-03-13','C# test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (3,'2005-03-11','JavaScript Test');
  
/* Real command */
SELECT ExamID, SustainedOn, Comments FROM Exam
WHERE ExamID IN (2, 7, 3);

           
         
    
  








Related examples in the same category

1. Date and Time Sizes, Formats, and Ranges
2.Define and check the date data type
3.Define and use Date data type
4.Show current date
5.Use date data type
6.Performing Range Tests 3
7.Performing Range Tests 1
8.Performing Range Tests 2
9.Convert Date to int
10.The date/time data types
11.Date and Time Column Types
12.Date and Time Sizes, Formats, and Ranges