Skip to content

Instantly share code, notes, and snippets.

@Ludovicmoreau
Last active October 4, 2016 12:33
Show Gist options
  • Save Ludovicmoreau/a135ad9cbd648ea9bd1f47170e600c0f to your computer and use it in GitHub Desktop.
Save Ludovicmoreau/a135ad9cbd648ea9bd1f47170e600c0f to your computer and use it in GitHub Desktop.
CREATE DATABASE Promotions_eleves;
CREATE TABLE ( id int not null auto_increment, Nom varchar(50), Prenom varchar(50), age int, Lieu_de_residence varchar(100),PRIMARY KEY (id));
insert into eleves(Nom, Prenom, Age, Lieu_de_résidence) values('lehoux','mickael',35,'orléans')
insert into eleves(Nom, Prenom, Age, Lieu_de_résidence) values('B','Joel',42,'Orleans')
insert into eleves(Nom, Prenom, Age, Lieu_de_résidence) values('google','good',18,'California')
insert into eleves(Nom, Prenom, Age, Lieu_de_résidence) values('laurie','MaMeilleureAmie',34,'Paris')
insert into eleves(Nom, Prenom, Age, Lieu_de_résidence) values('Paul','BIGBEN',34,'Paris')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment