SQLize | PHPize | SQLtest

create table emp( id int, name varchar(20), salary int, country varchar(15), dept varchar(10) ) insert into emp values (1,'adi',2000,'india','it'), (2,'kishore',4900,null,'hr'), (3,'sachin',6000,null,'hr'), (4,'manoj',5498,'india','it'), (5,'avinash',6458,'india','it'), (1,'adi',2000,'india','it'), (2,'kishore',4900,null,'hr') update emp set country ='USA' where country is null select * from emp; alter table emp add joindate date; UPDATE emp SET date = '2025-05-01', amount = 1200 WHERE id = 1; UPDATE emp SET date = '2025-05-02', amount = 1500 WHERE id = 2; UPDATE emp SET date = '2025-05-03', amount = 1800 WHERE id = 3; UPDATE emp SET date = '2025-05-04', amount = 2000 WHERE id = 4; UPDATE emp SET date = '2025-05-05', amount = 2200 WHERE id = 5; select * from emp;