数据库Mysql4：查询表数据select语句

1.查询数据select
select 列名1,列名2 from table_name;

select * from table_name；查询表所有的记录

select * from student where name=‘张三’；–查询张三记录

select * from student t where t.name lke ‘张%’;–模糊查询

select * from student t where t.score between ‘60’ and ‘80’;–按范围查询

select * from student t where t.name in(‘张三’,‘李四’);–按固定值查询

select name from student;
select name as n,chengji as j from student t;–别名查询：把name别名为n，把chengji别名为j，学生表student别名为t

select * from student limit 2;–查询2条记录

select distinct name from student;–查询去重值

select * from student where xueke=‘数学’ and score>60;–查询表下范围值

select * from student where xueke=‘数学’ and score=80;–查询表下范围值

select * from student where xueke=‘数学’ or xueke=‘语文’;–查询表下不同的值

select * from student order by score;–按照要求排序

select * from student order by score desc;–降序查询