mysql的基本查询操作

单表查询：（不加任何查询条件）

 select t_student.*
 from t_student

加上查询条件

 select t_student.*
        from t_student 
        where t_student.id = 1

连表查询

 select t_student.*, t_classes.class_name
        from t_student,
             t_classes
        where t_student.classes_id = t_classes.id
          and t_student.id =1

left join方式：

select t_student.*, t_classes.class_name
        from t_student
        left join t_classes on
        t_student.classes_id = t_classes.id
        where 1=1

查询总条数：

select count(id) from student where name="zhao"

按照顺序输出;

 select student.*
        (case when t_studnent.classId=1 then 2 else 3 end) remark
        from
        t_studnet
 order by remark
//先输出一班的学生，再输出二班的，再输出三班的