create\040user\040laurent
create\040user\040laurent;
quit
create\040database\040eleves;
quit
create\040database\040promo
create\040database\040promo;
use\040promo
create\040table\040eleves;
create\040table\040eleves\040(nom\040varchar(45),\040prenom\040varchar(45),\040age\040int,lieu_residence\040varchar(100));
show\040table\040eleves
show\040table\040eleves;
show\040database
;
show\040database;
grant\040all\040on\040'eleves'\040to\040laurent;
grant\040all\040on\040eleves\040to\040laurent;
exit
alter\040table\040eleves\040add\040column\040Id\040INT\040PRIMARY\040KEY\040NOT\040NULL;
alter\040table\040eleves\040add\040Id\040INT\040PRIMARY\040KEY\040NOT\040NULL;
use\040promo;
alter\040table\040eleves\040add\040Id\040INT\040PRIMARY\040KEY\040NOT\040NULL;
show\040eleves;
select\040*\040from\040eleves;
show\040columns\040from\040eleves;
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_naissance)\040values\040('Dalton1',\040'Dalton2',\040'Dalton3',\040'Dalton4',\040'Dalton5'),\040('Joe,\040'Jack',\040'William',\040'Averell',\040'Ma'),\040('45',\040'44',\040'43',\040'42',\040'85'),\040('cellule1',\040'cellule2',\040'cellule3',\040'cellule4',\040'Salt\040Lake\040City');
show\040table\040eleves;
show\040tables\040eleves;
show\040tables;
select\040*\040from\040eleves;
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_residence)\040values\040('Dalton',\040'Joe',\040'55',\040'cellule1'),\040('Dalton',\040'54',\040'cellule2'),\040('Dalton',\040'William',\040'53',\040'cellule3'),\040('Dalton',\040'Averell',\040'52',\040'cellule4'),\040('Dalton',\040'Ma',\040'85',\040'Boulder\040City');\040
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_residence)\040values\040('Dalton',\040'Joe',\040'55',\040'cellule1'),\040('Dalton',\040'Jack',\040'54',\040'cellule2'),\040('Dalton',\040'William',\040'53',\040'cellule3'),\040('Dalton',\040'Averell',\040'52',\040'cellule4'),\040('Dalton',\040'Ma',\040'85',\040'Boulder\040City');
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_residence,\040Id)\040values\040('Dalton',\040'Joe',\040'55',\040'cellule1',\040'1'),\040('Dalton',\040'Jack',\040'54',\040'cellule2',\040'2'),\040('Dalton',\040'William',\040'53',\040'cellule3',\040'3'),\040('Dalton',\040'Averell',\040'52',\040'cellule4',\040'4'),\040('Dalton',\040'Ma',\040'85',\040'Boulder\040City',\040'5');
select\040*\040from\040eleves;
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_residence)\040values\040('Wallace',\040'Laurie',\040'41',\040'Baltimore',\040'6');
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_residence,\040Id)\040values\040('Wallace',\040'Laurie',\040'41',\040'Baltimore',\040'6');
select\040*\040from\040eleves;
insert\040into\040eleves\040(nom,\040prenom,\040age,\040lieu_residence,\040Id)\040values\040('Google',\040'Chrome',\040'9',\040'Mountain\040View',\040'7');
select\040*\040from\040eleves;
SET\040CHARACTER\040SET\040'utf8';
SET\040collation_connection\040=\040'utf8_general_ci';
exit