Mysql04

1.  limit 查询行数

#limit 显示查询数据的行数
select  * from  test1 
limit 2;

2.修改表中数据

update  student set 
email='stu20000@163.com',loginPwd='000' where studentNo=20000;

3.创建表

select studentName,sex,BornDate,phone from student where gradeId=1;
create table student_grade1(
select studentName,sex,BornDate,phone from student where gradeId=1
)

4.更新数据

update subject set classHour=classHour-10  
where classHour>=200 AND gradeId=1;