SQLize | PHPize | SQLtest

-- Online SQL Editor to Run SQL Online. -- Use the editor to create new tables, insert data and all other SQL operations. -- Online SQL Editor to Run SQL Online. -- Use the editor to create new tables, insert data and all other SQL operations. create table Student( Sno int(5), Id int(10), Name varchar(20), dateofbirth int(15), Branch varchar(15), Marks int(5) ); insert into Student(Sno,Id,Name,dateofbirth,Branch,Marks)values ('01','20301','John','06/15/2004','CSE',85),('02','20307','Sweety','10/30/2004','CSE',65),('03','20310','Daisy','05/05/2005','MET',90),('04','20311','Jack','01/27/2005','IT',45),('05','20313','Lasya','02/07/2004','CIVIL',70),('06','20315','Anne','03/17/2004','CSE','60'),('07','20316','Shreya','09/23/2005','IT',92); alter table Student rename column Name to Student_Name; alter table Student drop column dateofbirth; select * from Student; TRUNCATE table Student;