student表
![](https://img-blog.csdn.net/20170829191715908?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWZjMTU4NzAw/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)
![](https://img-blog.csdn.net/20170829192137660?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQveWZjMTU4NzAw/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)
1.查询全部内容
SELECT
*
FROM
表的名字;
SELECT
*
FROM
student;
2.查询部分内容
SELECT 表中的属性如名字什么的(表名打点调用属性)
FROM
表的名字;
SELECT
student.name
FROM
student;
3.WHERE 条件查询
4.AND OR