MySQL 基础语句

多个知识点

------------------------------------------------------------------------------------------------------------------------------------------------------------

  • 排序:order by  desc-降序   asc-升序(默认)

select * from student order by stuno desc

  • distinct 去掉重复的值

select distinct classno from student

----------------insert----------------------------
select * from student
insert into student values('03000001','20102010','梁帅','abxdefgh')

-----------------update--------------------------
update student set stuname='梁帅帅' where stuname='梁帅'

-------------------delete----------------------------
delete 删除表中所有的记录,保持表的结构
delete table_name
-------------------drop------------------------
drop 完全删除表
drop table_name

04-25 19:09