Promotions

CREATE DATABASE Promotions_eleves;
CREATE TABLE ( id int, Nom varchar(50), Prenom varchar(50), age int, Lieu_de_residence varchar(100));
update Promotions SET Nom = 'Joel' WHERE id = 1;
update Promotions SET Prenom = 'Joel' WHERE id = 1;
update Promotions SET Lieu_de_résidence = 'Orleans' WHERE id = 1;
update Promotions SET age = 34 WHERE id = 1;
update Promotions SET Nom = 'Lehoux' WHERE id = 2;
update Promotions SET Prenom = 'Mickael' WHERE id = 2;
update Promotions SET Lieu_de_résidence = 'Orleans' WHERE id = 2;
update Promotions SET age = 35 WHERE id = 2;
update Promotions SET Nom = 'Louri' WHERE id = 3;
update Promotions SET Prenom = 'Louis' WHERE id = 3;
update Promotions SET Lieu_de_résidence = 'Orleans' WHERE id = 3;
update Promotions SET age = 24 WHERE id = 3;
update Promotions SET Nom = 'B' WHERE id = 4;
update Promotions SET Prenom = 'Anne-Laure' WHERE id = 4;
update Promotions SET Lieu_de_résidence = 'Orleans' WHERE id = 4;
update Promotions SET age = 28 WHERE id = 4;
update Promotions SET Nom = 'C' WHERE id = 5;
update Promotions SET Prenom = 'Maryse' WHERE id = 5;
update Promotions SET Lieu_de_résidence = 'Orleans' WHERE id = 5;
update Promotions SET age = 29 WHERE id = 1;