PHPize Online / SQLize Online  /  SQLtest Online

SELECT SIN(PI()/4), (4+1)*5; SELECT VERSION(), CURRENT_DATE; SELECT VERSION(); SELECT NOW();select user(); show databases; show tables; CREATE TABLE pet (name VARCHAR(20),owner VARCHAR(20),species VARCHAR(20),sex CHAR(1),birth DATE, death DATE); show tables; describe pet; INSERT INTO pet VALUES ('Fluffy','Harold','cat','f','1999-02-04',NULL); select * from pet; INSERT INTO pet VALUES ('Pinkey','Harold','dog','f','1959-02-04',NULL); INSERT INTO pet VALUES ('Buffly','Sarold','bird','f','1989-02-04',NULL); INSERT INTO pet VALUES ('Sffoly','Parold','rabbit','f','1979-02-04',NULL); INSERT INTO pet VALUES ('Finoloy','Narold','fish','f','1969-02-04',NULL); select * from pet; SELECT * FROM pet WHERE species = "dog" AND sex = "f"; SELECT * FROM pet WHERE birth >= "1979-02-04"; SELECT * FROM pet WHERE species = "fish" OR species = "bird"; select name, birth from pet; SELECT name, birth FROM pet ORDER BY birth; SELECT name, birth FROM pet ORDER BY birth DESC; SELECT COUNT(*) FROM pet;