sqlDataBase&Table

CREATE DATABASE eleves;

Interclassement : Utf-8;

CREATE TABLE eleve
(
id integer NOT NULL AUTO_INCREMENT,
nom varchar(150),
prenom varchar(150),
age integer,
ville varchar(150),
PRIMARY KEY (id)
);

sqlDatas

insert into eleves(nom, prenom, age, ville) values('lehoux','mickael',33,'orléans')
insert into eleves(nom, prenom, age, ville) values('wayne','bruce',42,'gotham')
insert into eleves(nom, prenom, age, ville) values('bond','james',45,'london')
insert into eleves(nom, prenom, age, ville) values('google','good',18,'Mountain View')
insert into eleves(nom, prenom, age, ville) values('laurie','MaMeilleureAmie',35,'Paris')