table consoles.txt

来自「codding for pszone one can use it at pl」· 文本 代码 · 共 4 行

CREATE TABLE CONSOLES(CONDITION CHAR(12) NOT NULL PRIMARY KEY,PLAYSTATION1 NUMBER NOT NULL,PLAYSTATION2 NUMBER NOT NULL,PSP NUMBER NOT NULL);
INSERT INTO CONSOLES VALUES('NEW',10,20,15);
INSERT INTO CONSOLES VALUES('SEMI-NEW',7,15,6);
INSERT INTO CONSOLES VALUES('SECOND-HAND',12,10,2);