CREATE DATABASE exemple; USE exemple; CREATE TABLE anniversaire(id INT(2) NOT NULL, nom TEXT NOT NULL, prenom TEXT NOT NULL, naissance DATE NOT NULL, PRYMARY KEY(id)); SHOW TABLES; DESCRIBE anniversaire; INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (1, "dupont", "charles", "1970/08/10"); INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (2, "dubois", "jacques", "1968/05/12"); INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (3, "dupuis", "antoine", "1973/11/02"); INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (4, "araneda", "claudio", "1970/07/16"); INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (5, "faucillon", "damien", "1980/08/30"); INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (6, "dupont", "madeleine", "1972/01/26"); INSERT INTO anniversaire(id, nom, prenom, naissance) VALUES (7, "picamal", "alexandra", "1980/10/16"); UPDATE anniversaire SET naissance="1980/08/31" WHERE id=5; SELECT * FROM anniversaire; DELETE FROM anniversaire WHERE nom="picamal"; SELECT nom, prenom FROM anniversaire WHERE id<4 ORDER BY naissance; CONNECT exemple; SELECT nom, prenom FROM anniversaire WHERE nom LIKE "d%"; \q