1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
CREATE TABLE TESTM
(
ID Integer,
TT Char(3),
NCC Integer,
NCT Integer,
TOT Integer
);
INSERT INTO TESTM (ID, TT, NCC, NCT, TOT) VALUES ('200', 'TT2', '10', '6', '30');
INSERT INTO TESTM (ID, TT, NCC, NCT, TOT) VALUES ('350', 'TT1', '9', '10', '30');
INSERT INTO TESTM (ID, TT, NCC, NCT, TOT) VALUES ('443', 'TT2', '11', '14', '20');
INSERT INTO TESTM (ID, TT, NCC, NCT, TOT) VALUES ('444', 'TT1', '12', '10', '30');
INSERT INTO TESTM (ID, TT, NCC, NCT, TOT) VALUES ('500', 'TT1', '12', '10', '30'); |
Partager