1 2 3 4 5 6 7 8 9 10
| CREATE TABLE TTT (EMP VARCHAR(8), Date_Record DATETIME, Action VARCHAR(8))
INSERT INTO TTT VALUES ('Paul', '2008-01-01 08:00:00', 'Entrée')
INSERT INTO TTT VALUES ('Paul', '2008-01-01 09:30:00', 'Sortie')
INSERT INTO TTT VALUES ('Paul', '2008-01-01 10:15:33', 'Entrée')
INSERT INTO TTT VALUES ('Paul', '2008-01-01 17:00:00', 'Sortie')
INSERT INTO TTT VALUES ('Marcel', '2008-01-01 08:22:00', 'Entrée')
INSERT INTO TTT VALUES ('Marcel', '2008-01-01 09:30:00', 'Sortie')
INSERT INTO TTT VALUES ('Marcel', '2008-01-01 10:25:33', 'Entrée')
INSERT INTO TTT VALUES ('Marcel', '2008-01-01 17:11:00', 'Sortie') |
Partager