SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE s ( s_no VARCHAR(255) PRIMARY KEY, sname VARCHAR(255) NOT NULL, status INTEGER NOT NULL, city VARCHAR(255) NOT NULL ); INSERT INTO s (s_no, sname, status, city) VALUES ('s1', 'Smith', 20, 'London'), ('s2', 'Jones', 10, 'Paris'), ('s3', 'Blake', 30, 'Paris'), ('s4', 'Clark', 20, 'London'), ('s5', 'Adams', 30, 'Athens'); CREATE TABLE p ( p_no VARCHAR(255) PRIMARY KEY, pname VARCHAR(255) NOT NULL, color VARCHAR(255) NOT NULL, city VARCHAR(255) NOT NULL ); INSERT INTO p (p_no, pname, color, city) VALUES ('p1', 'Nut', 'Red', 'London'), ('p2', 'Bolt', 'Green', 'Paris'), ('p3', 'Screw', 'Blue', 'Rome'), ('p4', 'Screw', 'Red', 'London'), ('p5', 'Cam', 'Blue', 'Paris'), ('p6', 'Cog', 'Red', 'London'); CREATE TABLE sp ( s_no VARCHAR(255) NOT NULL, p_no VARCHAR(255) NOT NULL, qty INTEGER NOT NULL, PRIMARY KEY (s_no, p_no), FOREIGN KEY (s_no) REFERENCES s(s_no), FOREIGN KEY (p_no) REFERENCES p(p_no) ); INSERT INTO sp (s_no, p_no, qty) VALUES ('s1', 'p1', 300), ('s1', 'p2', 200), ('s1', 'p3', 400), ('s1', 'p4', 200), ('s1', 'p5', 100), ('s1', 'p6', 100), ('s2', 'p1', 300), ('s2', 'p2', 400), ('s3', 'p2', 200), ('s4', 'p2', 200), ('s4', 'p4', 300), ('s4', 'p5', 400); ALTER TABLE s ADD COLUMN phone CHAR(10)