mysql -u etudiant -p -h servbd

SELECT colonne FROM table WHERE colonne>nombre;

SELECT Id, Name, Population, CountryCode FROM City WHERE CountryCode='FRA' AND Population>200000 ;

SELECT Id, Name, Population, CountryCode FROM City WHERE CountryCode='FRA' AND Population BETWEEN 200000 AND 500000 ;

SELECT Id, Name, Population, CountryCode FROM City WHERE Id BETWEEN 2974 AND 3013 OR Id BETWEEN 175 AND 183;

SELECT Id, Name, CountryCode FROM City WHERE CountryCode IN ('FRA', 'BEL') ;

SELECT Id, Name, CountryCode FROM City WHERE CountryCode IN ('FRA', 'BEL') AND Name<>'Paris';

SELECT Id, Name, Population, CountryCode FROM City WHERE Population IS NULL ;

SELECT Id, Name, Population, CountryCode FROM City WHERE CountryCode='FRA' ORDER BY Name ASC ;

SELECT Id, Name, Population, CountryCode FROM City WHERE CountryCode='FRA' ORDER BY Population DESC, Name ASC;

SELECT COUNT(Name) FROM City ;

COUNT(DISTINCT Name) FROM City ;

SELECT COUNT(Name) FROM City WHERE Name LIKE 'P%' ;

SELECT * FROM City WHERE Name LIKE 'A%' AND Population<=800000 AND Population>=500000 ;

SELECT COUNT(Name) FROM City WHERE CountryCode<>'FRA' AND CountryCode<>'BEl' AND CountryCode<>'ITA' ;

SELECT AVG(Population) FROM City WHERE CountryCode='ITA' AND Population>100000;

SELECT LENGTH(Name),Name,Population FROM City ORDER BY LENGTH(Name) DESC LIMIT 1;

SELECT ID,Name,Population/1000 AS 'Nb k habitants' FROM City WHERE CountryCode='GBR' ORDER BY Population DESC ;

insert into article (id,libelle,prix,description,stock,date) values (1,'tournevis plat taille 1', 45TYZ, 2.50, 'Superbe outil de marque', 50, '2018-07-25');

insert into article (id,libelle,fournisseur,prix,description,stock,date) values
(10,'tronçonneuse d''écran', EKRAN, 340, 'redimensionnez votre écran à volonté', default, '2016-02-29'),
(11,'clé plate de 11 à 13', 56TTT, 7, null, default, '2018-09-24');

select libelle,prix as prix_unitaire,stock,prix*stock as prix_total from article ;

insert into article (id,libelle,fournisseur,prix,description,stock,date) values (1,'tournevis plat taille 2', null, 3, 'nul', default, now());