SQLize | PHPize | SQLtest

create database College; use College; Create table stud( stud_id INT NOT NULL, name varchar(255), department varchar(255), college varchar(255), primary key(stud_id) ); INSERT INTO stud (stud_id,name,department,college)values (1,"John","cse","ABC"), (2,"ramu","ee","xyz"), (3,"raju","ce","pqr"); SELECT*FROM stud; CREATE TABLE sub( sub_id INT NOT NULL, sub_name VARCHAR(344), department VARCHAR(344), stud_id INT, Foreign key(stud_id) references stud(stud_id), Primary key(sub_id) ); INSERT INTO sub(sub_id,sub_name,department)VALUES (1,"os","cse",1), (2,"dbms","ee",2), (3,"geotech","ce",3); SELECT*FROM sub; ALTER table stud ADD email VARCHAR(255); SELECT*FROM stud; ALTER table sub DROP column sub_name; SELECT*FROM sub; alter table stud Rename column name to branch; Select*from stud;