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;