1.SELECT
a.选择所有数据
b.选择某列
c.选择多列
d.选择某行某列
其他WHERE语句
WHERE age between 32 and 38
WHERE gender='Male'
e. 排序
默认增序:order by age
降序排列:order by desc
2.DELETE语句
DELETE FROM employee WHERE name = 'mark'
3.INSERT语句
INSERT INTO employee(EmployeeID, Name, Surname, Age, Gender) VALUES(3, 'Tao', 'Jiang', 36, 'Male')
4.UPDATE语句
UPDATE employee set name = 'seaman' WHERE EmployeeID = 3
5. CREATE语句