MySQL实训学习笔记

基本查询语句：
select * from customer;
select id,name,sex from student
select id,name,sex from student where id => 1003;

select id,name,sex from student
where age >=18
and age <=35;

select id,name,sex from student
where age
between 18 and 35;

select * from student where age =18 or age =35 or age =23

select * from student where age in(18,23,35);

select * from student where name like ‘%小%’;

select * from student where name like ‘_明%’;

select * from student where email isnull;

mysql > select * from student where email is notnull;

select * from student order by age ; //升序

select * from student order by age desc ; //降序
insert into student(id,name) values(1001, ‘小明’);
update student set name=‘小红’ where id = 1001;
delete from student where id =1001;
drop table customer;