1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| CREATE DATABASE meuh;
USE meuh;
CREATE TABLE Prestation
(
idprest int not null,
abr varchar(30) not null,
quantite int not null,
datepr date not null,
ligne int not null,
CONSTRAINT PK_Prestation PRIMARY KEY (idprest)
) ENGINE = InnoDB;
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (1, "lol", 12, 23/01/2012, 1);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (2, "lol", 24, 23/01/2012, 2);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (3, "lol", 36, 23/01/2012, 3);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (4, "lol", 48, 23/01/2012, 4);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (5, "lol", 60, 23/01/2012, 5);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (6, "gneuh", 4, 23/01/2012, 1);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (7, "gneuh", 8, 23/01/2012, 2);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (8, "gneuh", 16, 23/01/2012, 3);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (9, "gneuh", 36, 23/01/2012, 4);
INSERT INTO Prestation (idprest, abr, quantite, datepr, ligne) VALUES (10, "gneuh", 64, 23/01/2012, 5); |
Partager