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 TABLE test_concours
( id int NOT NULL PRIMARY KEY,
concours varchar(25) NOT NULL,
score int NOT NULL,
nom varchar(16) NOT NULL);
INSERT INTO test_concours (id, concours, score, nom)
VALUES (1, 'superconcours', 45, 'tommy');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (2, 'superconcours', 56, 'bob');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (3, 'superconcours', 89, 'tommy');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (4, 'lo-cado', 52, 'tommy');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (5, 'lo-cado', 85, 'bob');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (6, 'cadomania', 39, 'bob');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (7, 'superconcours', 33, 'peter');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (8, 'cadomania', 45, 'peter');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (9, 'cadomania', 69, 'bob');
INSERT INTO test_concours (id, concours, score, nom)
VALUES (10, 'megaprix', 59, 'tommy'); |
Partager