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 46 47
| CREATE TABLE `A` (
`id_iti` SMALLINT( 255 ) NOT NULL,
`idA` INT( 255 ) NOT NULL
)
CHARACTER SET = latin1
COLLATE = latin1_general_ci
ENGINE = INNODB;
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (1 , 10 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (1 , 12 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (1 , 14 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (2 , 10 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (2 , 11 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (2 , 13 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (3 , 10 );
INSERT INTO `A` ( `id_iti`, `idA`) VALUES (3 , 11 );
CREATE TABLE `E` (
`idA` INT( 255 ) NOT NULL,
`idB` INT( 255 ) NOT NULL
)
CHARACTER SET = latin1
COLLATE = latin1_general_ci
ENGINE = INNODB;
INSERT INTO `E` ( `idB`, `idA`) VALUES (1 , 10 );
INSERT INTO `E` ( `idB`, `idA`) VALUES (2 , 11 );
INSERT INTO `E` ( `idB`, `idA`) VALUES (3 , 12 );
INSERT INTO `E` ( `idB`, `idA`) VALUES (4 , 13 );
INSERT INTO `E` ( `idB`, `idA`) VALUES (5 , 14 );
CREATE TABLE `C` (
`nom` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`idB` INT( 20 ) NOT NULL,
PRIMARY KEY ( `idB` )
)
CHARACTER SET = latin1
COLLATE = latin1_general_ci
ENGINE = INNODB;
INSERT INTO `BDTFX` ( `nom`, `idB`) VALUES ( 'nom1', 1 );
INSERT INTO `BDTFX` ( `nom`, `idB`) VALUES ( 'nom2', 2 );
INSERT INTO `BDTFX` ( `nom`, `idB`) VALUES ( 'nom3', 3 );
INSERT INTO `BDTFX` ( `nom`, `idB`) VALUES ( 'nom4', 4 );
INSERT INTO `BDTFX` ( `nom`, `idB`) VALUES ( 'nom5', 5 ); |
Partager