1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| insert into VH_vehicule(VH_immat)
values ('11-ABD-45')
, ('38-BEF-66')
, ('40-GAX-38')
, ('29-ZUT-17')
;
insert into PE_personne(PE_nom, PE_prenom)
values ('Naudin', 'Fernand')
, ('Volfoni', 'Raoul')
, ('Volfoni', 'Paul')
;
insert into CO_conduire (VH_ident, PE_ident, CO_dtdeb, CO_dtfin)
values (1, 1, '2023-01-01', '2023-12-31')
, (1, 3, '2024-01-01', '9999-12-31')
, (2, 1, '2020-06-30', '2023-01-10')
, (2, 3, '2023-01-11', '2023-04-18')
, (2, 2, '2023-04-19', '9999-12-31')
, (4, 1, '2023-01-11', '9999-12-31')
; |
Partager