CREATE TABLE t_etudiant(
pk_num_secu CHAR(13) PRIMARY KEY,
ck_num_etu VARCHAR(20) UNIQUE NOT NULL,
nom VARCHAR(50),
prenom VARCHAR(50));

INTO t_etudiant (pk_num_secu, ck_num_etu, nom, prenom)
(’1840791123456’, ’DUP1840703’, ’Dupont’, ’Pierre’);

INTO t_etudiant (pk_num_secu, ck_num_etu, nom, prenom)
(’2850460789101’, ’DUC2850428’, ’Durand’, ’Catherine’)

SELECT pk_num_secu, ck_num_etu, nom, prenom FROM t_etudiant;
SELECT * FROM t_etudiant;
SELECT nom, prenom FROM t_etudiant;