1 2 3 4 5 6 7 8 9 10 11
| CREATE TABLE DUMMY (PluCode INTEGER, ProductNumber INTEGER, PluNumber INTEGER);
COMMIT;
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (123456,13111,10);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (234567,13111,11);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (345678,13111,12);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (456789,54875,10);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (123456,13111,10);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (234567,13111,11);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (345678,13111,12);
INSERT INTO DUMMY (PluCode,ProductNumber,PluNumber) VALUES (456789,54875,10);
COMMIT; |