2024-BD-BUT1-Sen/Code/livraison.sql

23 lines
1000 B
MySQL
Raw Permalink Normal View History

2024-11-14 09:45:33 +01:00
--------------------------------------------------------
-- Fichier créé - jeudi-novembre-07-2024
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table LIVRAISON
--------------------------------------------------------
insert into livraison (dateliv, qtte, numcom) values
(to_date('30/08/87', 'DD/MM/RR'), '12', '2');
insert into livraison (dateliv, qtte, numcom) values
(to_date('15/07/87', 'DD/MM/RR'), '6', '1');
insert into livraison (dateliv, qtte, numcom) values
(to_date('27/09/87', 'DD/MM/RR'), '6', '2');
insert into livraison (dateliv, qtte, numcom) values
(to_date('20/11/87', 'DD/MM/RR'), '12', '3');
insert into livraison (dateliv, qtte, numcom) values
(to_date('20/12/87', 'DD/MM/RR'), '6', '4');
insert into livraison (dateliv, qtte, numcom) values
(to_date('28/12/87', 'DD/MM/RR'), '8', '6');
insert into livraison (dateliv, qtte, numcom) values
(to_date('30/12/87', 'DD/MM/RR'), '3', '7');