SQLize | PHPize | SQLtest

create table EMP0 ( id int, ename varchar(20), salary number ); insert into EMP0 values(53,'Dhanvi',25000); insert into EMP0 values(67,'Amit',30000); insert into EMP0 values(52,'utu',20000); select *from EMP0; insert into EMP0 values(24,'bhavesh',15000); select *from EMP0; alter table EMP0 add(ecity varchar(25)); update EMP0 SET ECITY='MUMBAI'; select *from EMP0; Delete column=salary from EMP0; select *from EMP0; alter table EMP0 drop column salary; select *from EMP0; alter table EMP0 add(salary number); update EMP0 SET salary=30000; select *from EMP0; update EMP0 SET salary=50000 where ename='Dhanvi'; select *from EMP0; select ename from EMP0; select ename,salary from EMP0; alter table EMP0 modify salary float; update EMP0 SET salary=29000.500 where salary=30000; select *from EMP0; update EMP0 SET ecity='Delhi' where ename='bhavesh'; select *from EMP0; delete from EMP0 where ecity='Delhi'; select *from EMP0; create table EMP1 ( id int, ename varchar(20), ecity varchar(10), salary number ); insert into EMP1 values(46,'Maitri','Mumbai',30000); insert into EMP1 values(20,'Devansh','Mumbai',30000); select *from EMP1; create view EMP0view as select id,ename; select *from EMP0view; select id,ename,salary,ecity from EMP0 right join ename on EMP1.ename=ename.EMP1;