SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE test ( id serial, name varchar ); INSERT INTO test (name) values ('Один'),('два'),('три'),('четыре'),(NULL); --DROP * --FROM test --WHERE id < 3; SELECT * FROM test WHERE name >= 'О' AND name < 'П'; CREATE TABLE PERSON ( ID INTEGER PRIMARY KEY, LAST_NAME VARCHAR(255) NOT NULL, FIRST_NAME VARCHAR(255) NOT NULL, AGE INTEGER ); ALTER TABLE PERSON ADD PRIMARY KEY (ID); CREATE TABLE PERSON ( ID INTEGER, LAST_NAME VARCHAR(255), FIRST_NAME VARCHAR(255) NOT NULL, AGE INTEGER, CONSTRAINT PK_Person PRIMARY KEY (ID, LAST_NAME) ); ALTER TABLE PERSON ADD CONSTRAINT PK_Person PRIMARY KEY (ID, LAST_NAME); ALTER TABLE PERSON DROP CONSTRAINT PK_Person; CREATE TABLE ORDER ( ORDER_ID INTEGER, ORDER_NUMBER INTEGER NOT NULL, PERSON_ID INTEGER, PRIMARY KEY (ORDER_ID), CONSTRAINT FK_PersonOrder FOREIGN KEY (PERSON_ID) REFERENCES PERSON(PERSON_ID) ); ALTER TABLE ORDER ADD CONSTRAINT FK_PersonOrder FOREIGN KEY (PERSON_ID) REFERENCES PERSON(PERSON_ID); ALTER TABLE ORDER DROP CONSTRAINT FK_PersonOrder; ------------------------------------------ CREATE TABLE ORDER ( ORDER_ID INTEGER PRIMARY KEY, ORDER_NUMBER INTEGER NOT NULL, PERSON_ID INTEGER REFERENCES PERSON(PERSON_ID) ); ALTER TABLE ORDER ADD FOREIGN KEY (PERSON_ID) REFERENCES PERSON(PERSON_ID);