mysql基本学习

 1.查orders表中对价格进行正序排序并且只查看ID字段

SELECT id FROM orders ORDER BY price asc

2.查orders表中对价格进行正序排序并且只查看ID和NAME字段

SELECT id,name FROM orders ORDER BY price asc

3.查数据库；查看所有的数据库命令

SHOW DATABASES

4.查oeders表中当价格大于10并且小于50 的数据 并且对其进行正序排序

SELECT * FROM orders WHERE price>10 and price <50 ORDER BY price asc

5.查oeders表中当ID大于等于100并且小于等于200并且价格大于等于200小于等于300的数据 

SELECT * FROM orders where id >=100 and id <= 200 and price >=200 and price <=300

6.查oeders表中当ID大于等于100并且小于200并且价格大于等于200小于等于300的数据或者价格大于等于500的数据 

SELECT * FROM orders where (id >=100 and id <= 200 and price >=200 and price <=300) OR price >=500

7.删除orders表中当ID=966的数据

DELETE FROM orders where id =966

8.更新当name=gaorui 的时候，将它的价格设置为666

UPDATE orders set price ='666' WHERE name ='gaorui'

9.查看name=gaorui 在orders 中的数据

SELECT * FROM orders WHERE name ='gaorui'