1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
CREATE TABLE adresse (
id_adresse INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
nom VARCHAR(50) NULL,
prenom VARCHAR(50) NULL,
code_postal INTEGER(4) UNSIGNED NULL,
localite VARCHAR(50) NULL,
PRIMARY KEY(id_adresse)
);
INSERT INTO `adresse` (`id_adresse`, `nom`, `prenom`, `code_postal`, `localite`) VALUES
(1, 'DUPONT', 'Frédéric', 7800, 'Ath'),
(2, 'GREGOIRE', 'Blaise', 7801, 'Irchonwelz');
CREATE TABLE province (
id_province INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
code_postal INTEGER(4) UNSIGNED NOT NULL,
localite VARCHAR(50) NOT NULL,
province VARCHAR(30) NOT NULL,
PRIMARY KEY(id_province)
);
INSERT INTO `province` (`id_province`, `code_postal`, `localite`, `province`) VALUES
(1, 7800, 'Ath', 'Hainaut'),
(2, 7800, 'Lanquesaint', 'Hainaut'),
(3, 7801, 'Irchonwelz', 'Hainaut'); |
Partager