## ceci est le fichier elf.mysql, résultat de la commande : ## mysqldump --user=anonymous --password=anonymous test elf > Tmp/elf.mysql ====================================================================== -- MySQL dump 10.9 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 4.1.15-Debian_1ubuntu5-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `elf` -- DROP TABLE IF EXISTS `elf`; CREATE TABLE `elf` ( `IDEN` varchar(4) NOT NULL default '', `SEXE` int(6) NOT NULL default '0', `AGE` int(5) NOT NULL default '0', `PROF` int(4) NOT NULL default '0', `ETUD` int(5) NOT NULL default '0', `REGI` int(5) NOT NULL default '0', `USAL` int(5) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `elf` -- /*!40000 ALTER TABLE `elf` DISABLE KEYS */; LOCK TABLES `elf` WRITE; INSERT INTO `elf` VALUES ('M001',1,62,1,2,2,3),('M002',0,60,9,3,4,1), ('M003',1,31,9,4,4,1),('M004',1,27,8,4,1,1),('M005',0,22,8,4,1,2), ('M006',1,70,4,1,1,1),('M007',1,19,8,4,4,2),('M008',1,53,6,2,2,3), ('M009',0,62,16,4,2,2),('M010',1,63,16,0,1,0),('M011',0,65,16,0,1,0), ('M012',1,11,12,2,4,2),('M013',0,78,16,3,4,1),('M014',0,20,8,4,4,2), ('M015',1,48,1,2,3,1),('M016',1,50,1,1,4,2),('M017',0,49,7,4,4,1), ('M018',1,44,1,1,2,1),('M019',1,21,8,4,2,2),('M020',1,23,13,3,1,2), ('M021',0,28,6,4,3,1),('M022',0,47,6,2,1,1),('M023',0,64,2,2,1,2), ('M024',0,26,8,4,4,1),('M025',1,14,12,2,1,2),('M026',0,43,1,1,1,2), ('M027',1,61,16,1,1,0),('M028',1,15,12,3,1,2),('M029',1,29,0,2,1,1), ('M030',1,24,1,2,1,2),('M031',1,41,9,4,1,1),('M032',1,37,9,4,2,1), ('M033',1,73,16,1,1,1),('M034',1,12,12,2,4,1),('M035',1,40,13,2,4,0), ('M036',0,42,7,3,3,0),('M037',1,15,12,2,2,0),('M038',0,16,12,3,4,0),('M039',1,46,1,2,4,1),('M040',1,61,9,2,2,1),('M041',1,19,8,4,1,0),('M042',0,20,8,3,1,0),('M043',1,73,16,4,4,0),('M044',1,39,13,4,4,0),('M045',1,59,1,2,4,0),('M046',0,22,1,0,4,0),('M047',0,52,1,2,3,0),('M048',1,76,16,3,1,0),('M049',1,17,12,3,4,0),('M050',1,44,9,3,3,0),('M051',0,28,9,4,2,0),('M052',1,25,13,3,0,0),('M053',1,28,6,4,4,0),('M054',1,26,9,4,4,0),('M055',1,50,13,2,4,0),('M056',0,28,7,4,4,0),('M057',0,52,6,2,4,0),('M058',1,31,11,3,4,0),('M059',0,29,7,4,4,0),('M060',0,28,5,4,4,0),('M061',0,30,7,4,4,0),('M062',1,28,6,4,4,0),('M063',1,30,7,4,4,0),('M064',0,26,6,3,4,0),('M065',0,29,6,3,4,0),('M066',0,32,7,4,4,0),('M067',1,26,1,3,4,0),('M068',1,27,6,4,4,0),('M069',0,27,9,4,4,0),('M070',1,28,13,2,4,0),('M071',0,35,6,2,4,0),('M072',1,35,6,4,4,0),('M073',0,33,7,4,4,0),('M074',1,18,12,3,1,0),('M075',1,21,1,2,1,0),('M076',0,17,8,4,2,0),('M077',1,19,1,2,1,0),('M078',1,18,1,3,1,0),('M079',0,18,1,2,1,0),('M080',1,24,1,3,4,0),('M081',1,25,6,4,4,0),('M082',1,19,1,2,4,0),('M083',1,25,8,4,4,0),('M084',0,25,9,4,1,0),('M085',1,73,16,3,1,0),('M086',1,60,2,2,1,0),('M087',1,49,9,4,2,0),('M088',0,47,9,4,2,0),('M089',1,22,6,4,1,0),('M090',1,15,12,2,1,0),('M091',1,50,13,2,1,0),('M092',1,36,9,4,2,0),('M093',1,13,12,2,1,0),('M094',0,12,12,2,1,0),('M095',1,31,6,4,0,0),('M096',1,17,12,3,1,0),('M097',1,39,1,2,1,0),('M098',0,62,6,3,1,0),('M100',1,48,9,4,2,0); UNLOCK TABLES; /*!40000 ALTER TABLE `elf` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;