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
|
--Insertion table 1
INSERT INTO TABLE1(CHAMP1,CHAMP2,....,CHAMP N) VALUES (1.VALUES1, 1.VALUES2,...1.VALUES N);
INSERT INTO TABLE1(CHAMP1,CHAMP2,....,CHAMP N) VALUES (2.VALUES1, 2.VALUES2,...2.VALUES N);
INSERT INTO TABLE1(CHAMP1,CHAMP2,....,CHAMP N) VALUES (3.VALUES1, 3.VALUES2,...3.VALUES N);
.
.
.
INSERT INTO TABLE1(CHAMP1,CHAMP2,....,CHAMP N) VALUES (N.VALUES1, N.VALUES2,...N.VALUES N)
-- Insertion table 2
INSERT INTO TABLE2(CHAMP1,CHAMP2,....,CHAMP N) VALUES (1.VALUES1, 1.VALUES2,...1.VALUES N);
INSERT INTO TABLE2(CHAMP1,CHAMP2,....,CHAMP N) VALUES (2.VALUES1, 2.VALUES2,...2.VALUES N);
INSERT INTO TABLE2(CHAMP1,CHAMP2,....,CHAMP N) VALUES (3.VALUES1, 3.VALUES2,...3.VALUES N);
.
.
.
INSERT INTO TABLE2(CHAMP1,CHAMP2,....,CHAMP N) VALUES (N.VALUES1, N.VALUES2,...N.VALUES N)
-- Insertion table N
INSERT INTO TABLE N(CHAMP1,CHAMP2,....,CHAMP N) VALUES (1.VALUES1, 1.VALUES2,...1.VALUES N);
INSERT INTO TABLE N(CHAMP1,CHAMP2,....,CHAMP N) VALUES (2.VALUES1, 2.VALUES2,...2.VALUES N);
INSERT INTO TABLE N(CHAMP1,CHAMP2,....,CHAMP N) VALUES (3.VALUES1, 3.VALUES2,...3.VALUES N);
.
.
.
INSERT INTO TABLE N(CHAMP1,CHAMP2,....,CHAMP N) VALUES (N.VALUES1, N.VALUES2,...N.VALUES N) |
Partager