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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| CREATE TABLE `eleves` (
`id` int(10) unsigned NOT NULL auto_increment,
`nom` char(15) character set latin1 collate latin1_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Contenu de la table `eleves`
--
INSERT INTO `eleves` (`id`, `nom`) VALUES
(1, 0x6d616368696e),
(2, 0x74727563),
(3, 0x626964756c65);
-- --------------------------------------------------------
--
-- Structure de la table `notes`
--
CREATE TABLE `notes` (
`eleve` int(10) unsigned NOT NULL,
`note` int(10) unsigned default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `notes`
--
INSERT INTO `notes` (`eleve`, `note`) VALUES
(1, 5),
(2, 5),
(1, 6),
(2, 5),
(1, 3),
(2, 7),
(1, 6),
(1, 8),
(2, 9),
(3, 1),
(3, 2),
(3, 4),
(3, 5),
(3, 12); |
Partager