SQLize Online / PHPize Online  /  SQLtest Online

-- create CREATE TABLE EMPLOYEE ( empId INTEGER PRIMARY KEY, name TEXT NOT NULL, dept TEXT NOT NULL, wtf TEXT NULL ); -- insert INSERT INTO EMPLOYEE (empId, name, dept) VALUES (0001, 'Clark', 'Sales'); INSERT INTO EMPLOYEE (empId, name, dept) VALUES (0002, 'Dave', 'Accounting'); INSERT INTO EMPLOYEE (empId, name, dept) VALUES (0003, 'Ava', 'Sales'); -- fetch SELECT * FROM EMPLOYEE WHERE dept = 'Sales'; SELECT * FROM EMPLOYEE WHERE dept = 'Sales' order by 'asc'; select 1-1 as result; select count(*) from information_schema.columns where table=EMPLOYEE; SELECT * FROM EMPLOYEE WHERE empId > 0 AND NAME != ''; SELECT * FROM EMPLOYEE WHERE empId > 5 union all (select 1 as a);-- AND NAME != '';