SQLize | PHPize | SQLtest

create TABLE t ( EmpID INT NOT NULL, NewVacationHours INT, ModifiedDate TIMESTAMP); INSERT INTO t values (1, 0, NULL); INSERT INTO t values (2, 0, NULL); INSERT INTO t values (3, 0, NULL); create TABLE t1 ( EmpID INT NOT NULL, NewVacationHours INT, ModifiedDate TIMESTAMP); INSERT INTO t1 values (1, 0, NULL); INSERT INTO t1 values (2, 0, NULL); INSERT INTO t1 values (3, 0, NULL); create TABLE Empl ( BusinessEntityID INT NOT NULL, VacationHours INT); INSERT INTO Empl values (1, 10); INSERT INTO Empl values (2, 20); INSERT INTO Empl values (3, 30); select NewVacationHours , e.VacationHours + 20, ModifiedDate FROM t, Empl AS e WHERE e.BusinessEntityID = EmpID; update Empl a set BusinessEntityID = BusinessEntityID + 1000 FROM t AS pt INNER JOIN t1 AS pt1 ON pt1.EmpID = pt.EmpID WHERE a.BUSINESSENTITYID = 10; select * from empl; update Empl as pe set BusinessEntityID = BusinessEntityID + 100 FROM Empl AS pe INNER JOIN t AS pt ON pe.BusinessEntityID = pt.EmpID WHERE pe.BusinessEntityID <= 2; DELETE FROM Empl as a FROM Empl INNER JOIN t AS pt ON Empl.BusinessEntityID = pt.EmpID WHERE Empl.BusinessEntityID > 2; UPDATE t SET NewVacationHours = e.VacationHours + 20 FROM Empl AS e WHERE e.BusinessEntityID = EmpID; select * from t; select * FROM Empl AS pe INNER JOIN t AS pt ON pe.BusinessEntityID = pt.EmpID WHERE pe.BusinessEntityID > 2; DELETE pe FROM Empl AS pe INNER JOIN t AS pt ON pe.BusinessEntityID = pt.EmpID WHERE pe.BusinessEntityID > 2; select * from Empl; update pe set pe.BusinessEntityID = pe.BusinessEntityID + 100 FROM Empl AS pe INNER JOIN t AS pt ON pe.BusinessEntityID = pt.EmpID WHERE pe.BusinessEntityID <= 2; select * from Empl; update Empl set BusinessEntityID = BusinessEntityID + 100 FROM Empl AS pe INNER JOIN t AS pt ON pe.BusinessEntityID = pt.EmpID WHERE pe.BusinessEntityID <= 2; select * from Empl; delete ta from t ta, t ta1 where ta.EmpID >= 3; select * from t; update t set ea.BusinessEntityID = 88 from t ta, empl ea where ta.EmpID > 100; select 1 FROM t, t ; drop table t; drop table empl;