sDb0EwM5

1DROP DATABASE IF EXISTS greg_b_wcs_bdx;
2
3CREATE DATABASE greg_b_wcs_bdx;
4
5USE greg_b_wcs_bdx;
6
7CREATE TABLE promo(
8    id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
9    nom VARCHAR(64) NOT NULL,
10    prenom VARCHAR(64) NOT NULL,
11    age INTEGER NOT NULL,
12    residence VARCHAR(128) NOT NULL
13);
14
15
16INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("innocenty","romain",29,"bordeaux");
17INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("guillou-camargo","arnaud",35,"gradignan");
18INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("bourbonnais","julien",35,"bordeaux");
19INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("bentejac","maxime",22,"Mertillac");
20INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("sahli","christel",29,"bordeaux");
21INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("diague","lucille",23,"bordeaux");
22INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("Google","Google",20,"st bernardino");
23INSERT INTO greg_b_wcs_bdx.promo (nom,prenom,age,residence) VALUES ("lorie","lorie",44,"paris");