SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS s; CREATE TABLE s ( s_no VARCHAR (10) NOT NULL , sname VARCHAR (10) NOT NULL , status INT NOT NULL , city VARCHAR(10) NOT NULL ); INSERT INTO s VALUES ("s1", "Smith", 20, "London"), ("s2", "Jones", 10, "Paris"), ("s3", "Blake", 30, "Paris"), ("s4", "Clark", 20, "London"), ("s5", "Adams", 30, "Athens") ; DROP TABLE IF EXISTS p; CREATE TABLE p ( p_no VARCHAR (10) NOT NULL , pname VARCHAR (10) NOT NULL , color VARCHAR (10) NOT NULL , city VARCHAR(10) NOT NULL ); INSERT INTO p 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") ; DROP TABLE IF EXISTS sp; CREATE TABLE sp ( s_no VARCHAR (10) NOT NULL , p_no VARCHAR (10) NOT NULL , qty INT NOT NULL ); INSERT INTO sp 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) SELECT * from s; SELECT * from p; SELECT * from sp;