SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bibliotheque
-- ----------------------------
DROP TABLE IF EXISTS `bibliotheque`;
CREATE TABLE `bibliotheque` (
`Code` int(10) NOT NULL auto_increment,
`NomsAuteurs` varchar(50) default NULL,
`NomsLivres` varchar(50) default NULL,
PRIMARY KEY (`Code`),
KEY `Code1` (`Code`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `bibliotheque` VALUES ('1', 'MR XXX', 'AAAA');
INSERT INTO `bibliotheque` VALUES ('2', 'MR XXX', 'BBBB');
INSERT INTO `bibliotheque` VALUES ('3', 'MR XXX', 'CCCC');
INSERT INTO `bibliotheque` VALUES ('4', 'MR YYY', 'DDDD');
INSERT INTO `bibliotheque` VALUES ('5', 'MR YYY', 'EEEE');
INSERT INTO `bibliotheque` VALUES ('6', 'MR ZZZ', 'FFFF');
Partager