SQLize Online / PHPize Online  /  SQLtest Online

/*Enriquez, Reinz G. - BSIT2A - May01, 2022*/ CREATE TABLE tblEmployee ([EMPNO] int, [NAME] varchar(20), [SALARY] float, [HIRED_DATE] date, [STATUS] varchar(15)); INSERT INTO tblEmployee ([EMPNO], [NAME], [SALARY], [HIRED_DATE], [STATUS]) VALUES (1001, 'Juan Cruise', 20500.00, '2008-03-25', 'FullTime'), (1002, 'Gabriela Silang', 19500.00, '2010-07-30', 'FullTime'), (1003, 'Pedro Cruise', 29300.00, '2005-01-15', 'FullTime'), (1004, 'Jose Rizal', 16200.00, '2013-02-23', 'PartTime'), (1006, 'Terio Balutlot', NULL, '2009-05-09', 'FullTime'), (1007, 'Lenny Panogalog', 27700.00, '2005-01-15', 'PartTime'), (1005, 'Lolit Bando', 39200.00, '2005-01-15', 'FullTime'), (1011, 'Chona Hermosa', NULL, '2009-08-23', 'PartTime'); UPDATE tblEmployee SET NAME='Tom Cruise' WHERE EMPNO=1003;