SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Writers(Author Text, Age Int, PRIMARY KEY(Author)); CREATE TABLE Books(Bid Int, Title Text, Author Text); ALTER TABLE Books ADD CONSTRAINT constraint0 PRIMARY KEY(Bid); ALTER TABLE Books ADD CONSTRAINT constraint1 FOREIGN KEY(Author) REFERENCES Writers(Author); INSERT INTO Writers VALUES('John', 10); INSERT INTO Writers VALUES('Johnny', 1000); INSERT INTO Books VALUES(10, 'HOW TO LIVE A JOHNNY', 'Johnny'); UPDATE Writers SET AGE = 100 WHERE Age > 100; SELECT * FROM Writers; DELETE FROM Writers WHERE AGE = 100; SELECT * FROM BOOKS;