DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(matricule INT(4) KEY NOT NULL field_format='Z', nom VARCHAR(16) NOT NULL, prenom VARCHAR(20) NOT NULL, sexe SMALLINT(1) NOT NULL COMMENT'sexe 1:M 2:F', aanais INT(4) NOT NULL, mmnais INT(2) NOT NULL, ddentree INT(6) NOT NULL, ddnom INT(6) NOT NULL, brut INT(6) NOT NULL, net DOUBLE(8,2) NOT NULL, service INT(2) NOT NULL, sitmat CHAR(1) NOT NULL, formation CHAR(5) NOT NULL, INDEX NP(nom,prenom)) ENGINE=CONNECT TABLE_TYPE=FIX ENDING=2;
INSERT INTO t1 VALUES (9692,'VICENTE','LAURENCE ',2,1941, 8,196710,198901,16212,13032.80, 0,'M','ANGL');
INSERT INTO t1 VALUES (9146,'NICOLAS','ROGER ',1,1941, 6,196407,199502,34173,25098.65, 0,'M','SANS');
INSERT INTO t1 VALUES (2985,'TESSEREAU','MARIE HELENE ',2,1941, 9,196701,199001,19323,14933.78, 0,'V','SANS');
INSERT INTO t1 VALUES (3368,'MOGADOR','ALAIN ',1,1941, 1,196109,199311,43303,31420.55, 0,'C','SANS');
INSERT INTO t1 VALUES (7394,'CHAUSSEE','ERIC DENIS ',1,1944, 9,196511,198312,32002,23583.86, 0,'M','ANGL');
INSERT INTO t1 VALUES (4655,'MAILLOT','GEORGES ',1,1945, 5,197009,198612,24700,18541.64, 0,'C','ANGL');
INSERT INTO t1 VALUES (2825,'CAMILLE','NADINE ',2,1956, 9,199401,199301,19494,15050.45, 0,'M','SANS');
INSERT INTO t1 VALUES (1460,'BRUYERES','JEAN MARC ',1,1958, 8,198408,198805,20902,15980.07, 0,'M','SANS');
INSERT INTO t1 VALUES (7761,'KAMAL','ALAIN ',1,1948, 9,197704,199311,14715,12024.08, 1,'M','COMPT');
INSERT INTO t1 VALUES (5772,'GAUTHIER','SABINE ',2,1948, 6,197707,199404,14715,12025.34, 1,'M','TECHN');
INSERT INTO t1 VALUES (9643,'BARTHELEMY','DOMINIQUE ',1,1949, 5,198710,199011,11131, 9657.16, 1,'L','SANS');
INSERT INTO t1 VALUES (3906,'ROUYRE','LAURE ',2,1949, 3,197307,197207,13266,11016.21, 1,'M','SANS');
INSERT INTO t1 VALUES (8707,'SICILE','JEAN PIERRE ',1,1950, 1,197607,199301,13693,11286.56, 1,'M','ANGL');
INSERT INTO t1 VALUES (0091,'THIVERNAL','DIDIER JEAN ',1,1951,10,198005,199110,14715,12024.71, 1,'M','SANS');
INSERT INTO t1 VALUES (5757,'CLOPERIE','FABIENNE ',2,1951, 7,197205,199507,16848,13423.26, 1,'M','SANS');
INSERT INTO t1 VALUES (7795,'LATOUR','CATHERINE ',2,1952, 4,199406,199306, 8359, 7953.72, 1,'M','SANS');
INSERT INTO t1 VALUES (4879,'EGUILLES','GILLES ',1,1952, 6,197212,199007,16212,13032.51, 1,'M','ANGL');
INSERT INTO t1 VALUES (8311,'VINS','JEAN PIERRE ',1,1952, 1,199309,199209,10407, 9272.06, 1,'M','TECHN');
INSERT INTO t1 VALUES (5964,'JUST','STEPHANE BERNARD ',1,1952, 5,197406,199301,13693,11286.48, 1,'M','SANS');
INSERT INTO t1 VALUES (2822,'NEMAN','ELISABETH ',2,1952, 7,199304,199204, 9597, 8728.14, 1,'M','SANS');
INSERT INTO t1 VALUES (1340,'ABBE','MICHELE ',2,1953,10,197307,199104,15781,12722.60, 1,'M','SANS');
INSERT INTO t1 VALUES (0571,'DOMINICAINES','JERZY ',1,1952, 3,197110,199101,32002,23582.94, 6,'M','SANS');
INSERT INTO t1 VALUES (0382,'KERHAM','CATHERINE ',2,1952, 2,197404,199107,15781,12722.07, 6,'M','SANS');
INSERT INTO t1 VALUES (8150,'BEARN','FRANCK ',1,1952, 2,198209,199301,15271,12372.87, 6,'M','SANS');
INSERT INTO t1 VALUES (7995,'BAUDIN','DANIEL ',1,1953, 9,197505,199401,13693,11287.19, 6,'M','SANS');
INSERT INTO t1 VALUES (4159,'CHASSENARD','JEAN BERNARD ',1,1953, 5,198706,198606,10791, 9503.21, 6,'M','SANS');
INSERT INTO t1 VALUES (3964,'FAREMOUTIERS','LAURENCE ',2,1953, 6,199311,199211, 8656, 8145.08, 6,'M','SANS');
INSERT INTO t1 VALUES (0454,'CHERBOURG','ISABELLE ',2,1953, 6,199610,199510, 7803, 7679.81, 6,'M','VENTE');
INSERT INTO t1 VALUES (5111,'CROIZAT','CHRISTOPHE ',1,1953,11,197303,199007,15781,12722.69, 6,'M','ALLEM');
INSERT INTO t1 VALUES (2014,'LISIERE','XAVIER ',1,1953, 8,198911,199501, 9894, 8923.22, 6,'M','SANS');
INSERT INTO t1 VALUES (9741,'PARIS','PASCAL ELIE ',1,1954,10,197808,199101,20221,15555.53, 6,'M','TECHN');
INSERT INTO t1 VALUES (0737,'YERRES','GERARD ',1,1954, 6,197609,199504,25299,18968.84, 6,'M','TECHN');
INSERT INTO t1 VALUES (3053,'TORRE','PAULE ',2,1955, 9,197606,199510,18813,14585.97, 6,'M','VENTE');
INSERT INTO t1 VALUES (2120,'CORMEILLE','JEAN LUC ',1,1955, 5,199610,199510, 8656, 8146.74, 6,'M','SANS');
INSERT INTO t1 VALUES (1540,'PIJOUNIE','ANGELE ',2,1956, 5,197702,198109,18345,14274.87, 6,'M','ANGL');
INSERT INTO t1 VALUES (6259,'VICQ','CATHERINE COLETTE ',2,1956, 2,197807,197707,10668, 9425.82, 6,'M','SANS');
INSERT INTO t1 VALUES (8345,'DAGOBERT','DJARN ',1,1956, 7,198209,198711,11131, 9658.24, 6,'M','INFOR');
INSERT INTO t1 VALUES (3734,'GARNIER','PASCAL FRANCOIS ',1,1956,10,197708,199404,22012,16756.71, 6,'M','SANS');
INSERT INTO t1 VALUES (4365,'ESSO','ANTOINE ',1,1956,12,197606,199401,13693,11288.10, 6,'M','SANS');
INSERT INTO t1 VALUES (0262,'ROLLAT','HERVE ',1,1956,11,197908,199101,21757,16601.93, 6,'M','SANS');
INSERT INTO t1 VALUES (7989,'RHONE','YVES ',1,1956, 7,197705,199404,12499,10472.06, 6,'M','ANGL');
INSERT INTO t1 VALUES (4035,'ISLIP','ANNIE CLAUDE ',2,1957, 4,199310,199201,12499,10472.06, 6,'M','INFOR');
INSERT INTO t1 VALUES (8638,'DUNOIS','JACQUES ',1,1957, 5,198103,199506,22737,17260.50, 6,'M','INFOR');
INSERT INTO t1 VALUES (6417,'ALBI','RENE ',1,1957,11,198009,199312,13693,11288.04, 6,'M','ANGL');
INSERT INTO t1 VALUES (7559,'MARIENTHAL','MONIQUE ',2,1958, 3,199409,199304,11389, 9852.59, 6,'M','SANS');
INSERT INTO t1 VALUES (1621,'CAMBRIDGE','ALAIN ',1,1958, 8,199312,199212, 9597, 8729.04, 6,'M','INFOR');
INSERT INTO t1 VALUES (3476,'CREPY','ALICE ',2,1958,11,198711,198611, 9511, 8688.22, 6,'M','SANS');
INSERT INTO t1 VALUES (2482,'CHORON','EVELYNE ',2,1958, 7,199110,199409, 8656, 8145.42, 6,'.','SANS');
INSERT INTO t1 VALUES (4165,'BALZAC','MICHEL ',1,1958, 7,198512,199501,14332,11713.76, 6,'M','SANS');
INSERT INTO t1 VALUES (9040,'FERDINAND','CHARLES ',1,1958,12,197810,197710,11389, 9852.24, 6,'M','ANGL');
INSERT INTO t1 VALUES (6858,'CUVRAY','MARTINE ',2,1959, 7,198004,199401,14715,12025.82, 6,'M','MARKT');
INSERT INTO t1 VALUES (2723,'PAPARA','FRANCOISE ',2,1959, 6,198005,199401,14715,12025.70, 6,'M','TECHN');
INSERT INTO t1 VALUES (1222,'FOSSES','MONIQUE ',2,1959, 2,198004,199312,18045,14081.78, 6,'M','TECHN');
INSERT INTO t1 VALUES (6998,'HONORE','PATRICIA ',2,1965, 3,198905,199401,13819,11366.18, 6,'D','SANS');
INSERT INTO t1 VALUES (0086,'COLLETTE','SERGE ',1,1965, 4,198509,199112,12882,10744.14, 6,'M','ALLEM');
INSERT INTO t1 VALUES (2914,'ESPAGNET','ERWAN ',1,1965, 2,198405,198305,12882,10744.17, 6,'M','SANS');
INSERT INTO t1 VALUES (9284,'COLIBRIS','JEAN JACQUES ',1,1965, 4,199310,199210,13306,11018.00, 6,'M','TECHN');
INSERT INTO t1 VALUES (3214,'NELSON','JEAN YVES ',1,1974, 2,199412,199312, 8359, 7953.60, 6,'C','INFOR');
INSERT INTO t1 VALUES (4394,'BRIAND','JOSETTE ',2,1954, 7,197505,199501,18813,14584.61, 7,'M','ALLEM');
INSERT INTO t1 VALUES (6207,'FOINS','CLARISSE ',2,1954,12,197607,199201,15781,12723.18, 7,'C','SANS');
INSERT INTO t1 VALUES (9748,'CHARVE','MARIE CLAUDE ',2,1954, 1,199103,198801, 9894, 8921.67, 7,'M','SANS');
INSERT INTO t1 VALUES (9682,'TIPHAINE','JEAN CLAUDE ',1,1955,10,197809,199404,14715,12026.06, 7,'M','INFOR');
INSERT INTO t1 VALUES (1788,'NAJY','ALAIN ',1,1955, 1,197503,199107,15781,12721.89, 7,'M','INFOR');
INSERT INTO t1 VALUES (7956,'NOTAIRE','FRANCOISE MADELEINE ',2,1955, 3,197701,198104,16848,13422.41, 7,'M','SANS');
INSERT INTO t1 VALUES (3415,'PRAIRIE','PASCALE ',2,1956, 7,199112,199012,10024, 8999.63, 7,'M','SANS');
INSERT INTO t1 VALUES (9208,'ESCADENIERES','JEAN FRANCOIS ',1,1956, 6,198408,199301,14715,12026.22, 7,'M','SANS');
INSERT INTO t1 VALUES (0945,'MAISON','HEIKE ',2,1956,12,197702,199201,14715,12024.30, 7,'M','SANS');
INSERT INTO t1 VALUES (2271,'LANDE','MICHEL ',1,1957, 4,198202,199401,14715,12025.56, 7,'M','SANS');
INSERT INTO t1 VALUES (8437,'ORANGERI','DANIEL ',1,1969, 3,198904,199212,12499,10473.15,13,'C','SANS');
INSERT INTO t1 VALUES (4233,'LEBLANC','CHRISTIAN ',1,1970, 4,199101,199001,10024, 8999.31,13,'M','ANGL');
INSERT INTO t1 VALUES (2043,'RAVEL','FRANCOISE ',2,1970,10,199301,199201, 9597, 8728.89,13,'M','SANS');
INSERT INTO t1 VALUES (4748,'REDONDO','CHRISTINE ',2,1970,11,199408,199308,12069,10241.30,13,'C','INFOR');
INSERT INTO t1 VALUES (6379,'ROUGE','CATHERINE ',2,1970, 1,199401,199201,12028,10241.72,13,'M','ALLEM');
INSERT INTO t1 VALUES (4507,'ALBAN','CATHERINE ',2,1970, 9,199301,199101,12028,10240.98,13,'M','SANS');
INSERT INTO t1 VALUES (6496,'BEL','CATHERINE EMILIENNE ',2,1972,11,199202,199102,11389, 9851.34,13,'M','ESP');
INSERT INTO t1 VALUES (4096,'XAVIER','THIERRY ',1,1973, 3,199512,199510,12882,10745.85,13,'C','SANS');
INSERT INTO t1 VALUES (0302,'FRANCH','WILLIAM ',1,1973, 8,199502,199402, 9894, 8922.86,13,'C','SANS');
INSERT INTO t1 VALUES (1195,'GUILBERT','ELISABETH ',2,1973, 8,199303,199203,11389, 9851.41,13,'C','SANS');
INSERT INTO t1 VALUES (8888,'LEGER','BERNADETTE ',2,1973, 7,199409,199309, 9126, 8455.98,13,'C','SANS');
INSERT INTO t1 VALUES (9415,'FONTANEY','MARIE PAULE ',2,1973, 4,199404,199304, 9894, 8922.41,13,'M','SANS');
INSERT INTO t1 VALUES (8921,'ROSA','SUZANNE ',2,1974,10,199408,199308,10668, 9426.34,13,'C','VENTE');
INSERT INTO t1 VALUES (1867,'BASSE','JOCELYNE ',2,1974, 6,199404,199304, 9894, 8923.17,13,'M','SANS');
INSERT INTO t1 VALUES (1798,'RUSSE','THIERRY ',1,1974, 4,199401,199301, 9894, 8923.31,13,'C','ANGL');
INSERT INTO t1 VALUES (8684,'CHEM','BERTRAND ',1,1975, 6,199407,199307, 7803, 7680.39,13,'C','SANS');
INSERT INTO t1 VALUES (3841,'UTRILLO','JACQUES ',1,1976,11,199506,199406, 7803, 7681.16,13,'C','SANS');
INSERT INTO t1 VALUES (6399,'ABEILLES','RENE ',1,1934, 7,199207,199107, 9511, 8687.51,14,'M','SANS');
INSERT INTO t1 VALUES (1983,'PETUNIAS','MICHELLE ',2,1935, 1,199208,199501, 7803, 7680.26,14,'.','SANS');
INSERT INTO t1 VALUES (0006,'DOMONT','YVES ',1,1935,11,198810,198509, 8656, 8145.39,14,'.','ALLEM');
INSERT INTO t1 VALUES (6326,'JATELIER','CHRISTIAN ',1,1935,11,199107,198509, 8656, 8146.09,14,'.','ANGL');
INSERT INTO t1 VALUES (5224,'MAGNOLIAS','MICHELE ',2,1936, 3,196211,199107,22737,17260.26,14,'M','SANS');
INSERT INTO t1 VALUES (1839,'ANSELME','REMY ',1,1937, 2,196312,199401,15570,12567.77,14,'M','SANS');
INSERT INTO t1 VALUES (6250,'ASPREMONT','JEAN LUC ',1,1937, 9,196808,199007,14332,11715.65,14,'M','ALLEM');
INSERT INTO t1 VALUES (2328,'AGE','MARIE HELENE ',2,1937, 8,196607,199510,20178,15518.09,14,'M','SANS');
INSERT INTO t1 VALUES (1178,'NAPOLEON','HELENE ',2,1938, 6,196707,199007,15781,12723.27,14,'C','ANGL');
INSERT INTO t1 VALUES (6569,'GAULLE','JEAN CLAUDE ',1,1962, 9,198904,199212,12499,10472.30,15,'M','SANS');
INSERT INTO t1 VALUES (6715,'SEINE','KARL ',1,1962, 7,198402,198302,11131, 9657.12,15,'M','SANS');
INSERT INTO t1 VALUES (3136,'GOBELINS','JEAN PIERRE ',1,1962, 2,199309,199201,12499,10472.30,15,'M','SANS');
INSERT INTO t1 VALUES (5291,'LAMBERTIANAS','MARIE CLAUDE ',2,1962, 7,199506,199406, 9126, 8457.56,15,'D','SANS');
INSERT INTO t1 VALUES (6342,'MISSECLE','DIDIER ',1,1963, 4,198911,198811,15399,12453.60,15,'M','SANS');
INSERT INTO t1 VALUES (3447,'VIAL','GEORGES ',1,1963, 5,198504,198411,15271,12374.34,15,'M','ALLEM');
INSERT INTO t1 VALUES (5045,'GRAZAILLES','LAURE ',2,1963, 8,199108,199008, 8656, 8146.97,15,'.','INFOR');
INSERT INTO t1 VALUES (7974,'CHAUSSEE','PAUL ',1,1963, 6,198507,199112,12882,10743.92,15,'M','SANS');
INSERT INTO t1 VALUES (2189,'PEYBERT','DIDIER ',1,1963, 8,198308,198811,20902,15980.46,15,'M','SANS');
INSERT INTO t1 VALUES (7262,'JOZE','PATRICK JEAN ',1,1963, 9,198311,198211,13266,11017.41,15,'M','SANS');
INSERT INTO t1 VALUES (8222,'ETANG','LIONEL ',1,1963, 7,198501,199303,16936,13497.90,15,'M','SANS');
INSERT INTO t1 VALUES (6881,'OUEST','OLIVIER ',1,1963,12,198404,198402,10791, 9502.08,15,'M','SANS');
INSERT INTO t1 VALUES (8121,'MADELEINE','JEAN ',1,1964,10,198407,198312,12882,10745.18,15,'C','ESP');
INSERT INTO t1 VALUES (6828,'CONCY','JEAN MICHEL ',1,1964, 9,198804,199409,16936,13499.22,15,'M','ALLEM');
INSERT INTO t1 VALUES (3939,'CHURCHILL','BRIGITTE ',2,1964,10,199202,199102,13306,11016.60,15,'M','SANS');
INSERT INTO t1 VALUES (5116,'PEREIRE','DIDIER PAUL ',1,1964, 2,198607,199212,12882,10745.99,15,'M','SANS');
INSERT INTO t1 VALUES (2174,'TEISSEIRE','ELFRIEDE ',2,1964, 4,199212,199112, 8656, 8145.56,15,'.','ANGL');
INSERT INTO t1 VALUES (0585,'CRETS','LAURENCE ',2,1965, 3,199306,199209, 9597, 8728.84,15,'M','SANS');
INSERT INTO t1 VALUES (7988,'DOMAINE','PASCAL ',1,1965, 6,198405,199307,15271,12372.87,15,'M','SANS');
INSERT INTO t1 VALUES (4302,'KERCADORET','DOMINIQUE ',1,1971, 8,199407,199307,12069,10240.23,64,'C','SANS');
INSERT INTO t1 VALUES (1236,'PALETTE','ROSE MAY ',2,1971, 9,199403,199303,12672,10588.92,64,'C','SANS');
INSERT INTO t1 VALUES (8225,'SEROT','MARTINE ',2,1972, 1,199206,199203,13306,11017.70,65,'C','ALLEM');
INSERT INTO t1 VALUES (5326,'DRAGUIGNAN','FRANCOISE ',2,1972, 5,199306,199206,11389, 9852.05,64,'M','TECHN');
INSERT INTO t1 VALUES (5970,'DANUBE','PHILIPPE ',1,1974, 1,199407,199307,12069,10240.49,65,'C','SANS');
INSERT INTO t1 VALUES (6556,'BROUILLET','ANTOINE ',1,1937, 1,198610,198601,26878,20055.05,65,'.','SANS');
INSERT INTO t1 VALUES (1186,'AOUT','JEAN JACQUES ',1,1937, 2,198701,198601,24316,18272.01,65,'.','COMPT');
INSERT INTO t1 VALUES (7999,'PIERREFONDS','STEPHANE ',1,1938, 3,196405,199401,16636,13342.76,65,'M','INFOR');
INSERT INTO t1 VALUES (1312,'GRENOUILLERE','PHILIPPE ',1,1939, 7,196410,198701,64003,45693.24,65,'M','ALLEM');
INSERT INTO t1 VALUES (0460,'MARRONNIERS','GERARD ',1,1942, 4,196106,199411,35878,26261.79,65,'M','INFOR');
INSERT INTO t1 VALUES (4154,'LOUIS','PHILIPPE ',1,1942,12,196510,199301,27390,20403.30,65,'M','VENTE');
INSERT INTO t1 VALUES (3603,'MUETTE','GEORGES CHARLES ',1,1942, 4,196807,199201,38442,28044.84,65,'M','ANGL');
INSERT INTO t1 VALUES (8992,'COUDREE','PASCAL ',1,1943, 9,196803,198807,22737,17260.32,65,'M','SANS');
INSERT INTO t1 VALUES (9382,'CONSTANCE','MADELEINE ',2,1944, 5,198306,198602,11131, 9657.12,65,'V','SANS');
INSERT INTO t1 VALUES (0255,'MARTINIQUE','GERARD ',1,1946, 3,199412,199312,38824,28316.73,65,'M','SANS');
INSERT INTO t1 VALUES (8195,'EXELMANS','BERNARD ',1,1946, 9,198405,198411,12157,10278.16,65,'M','VENTE');
INSERT INTO t1 VALUES (3879,'GOUT','JACQUES ',1,1947, 5,196812,199212,24700,18540.57,65,'M','SANS');
INSERT INTO t1 VALUES (9678,'HETRES','VIANNEY ',1,1947, 9,196809,199409,41214,28006.17,65,'M','ALLEM');
INSERT INTO t1 VALUES (6027,'STRASBOURD','JEAN CLAUDE ',1,1951, 2,197210,198705,24700,18540.15,65,'M','ALLEM');
INSERT INTO t1 VALUES (7805,'BESSIERES','JEAN ',1,1952, 5,197303,198811,23340,17609.42,65,'M','SANS');
INSERT INTO t1 VALUES (7152,'REUILLY','ANNE ',2,1953, 9,197407,199312,14715,12024.56,65,'M','INFOR');
INSERT INTO t1 VALUES (4995,'BERCHET','FRANCOISE ',2,1954,12,199306,199206, 8656, 8145.60,65,'M','MANAG');
INSERT INTO t1 VALUES (1933,'ERMITAGE','JEAN CLAUDE ',1,1955, 1,199103,199402,12499,10471.61,65,'M','SANS');
INSERT INTO t1 VALUES (0728,'VOISEMBERT','ISABELLE ',2,1955, 6,197601,199101,14715,12024.21,65,'M','SANS');
INSERT INTO t1 VALUES (0718,'CERNAY','MARC JEAN MARIE ',1,1959, 1,198801,198701,36691,26843.73,65,'.','SANS');
INSERT INTO t1 VALUES (2726,'ORDENER','MARIE FRANCOISE ',2,1959, 2,198007,199110,13693,11287.97,65,'M','SANS');
INSERT INTO t1 VALUES (0225,'PLELO','PHILIPPE ',1,1959,11,198003,197903,11389, 9851.33,65,'M','SANS');
INSERT INTO t1 VALUES (0630,'GOBELINS','BERNARD ',1,1959, 7,198103,199101,27819,20674.61,65,'M','TECHN');
INSERT INTO t1 VALUES (1138,'ISARDS','ELIANE ',2,1960, 2,198810,199004,25815,19316.58,65,'.','SANS');
CREATE TABLE t2 (matricule INT(4) KEY NOT NULL, nom VARCHAR(16) NOT NULL, prenom VARCHAR(20) NOT NULL, INDEX NP(nom,prenom)) ENGINE=CONNECT TABLE_TYPE=MYSQL CONNECTIOn='mysql://root@localhost/test/t1';
SELECT matricule, nom, prenom FROM t2 ORDER BY nom,prenom LIMIT 10;
