让你快速复习语句的笔记宝典。
create table users( username varchar(20) primary key, userpwd varchar(20) )
alter table users add age int insert into stu (sname)values('sdfdsfdsfeeeeee')
update cj set cj=60 where sid=1
delete from cj where sid=2
--所有行所有列 select * from stu --某一些行所有列 select * from stu where sid>3 --某一些行某一些列 select sname from stu where sid>=3 --某一列所有行 select sname from stu --mysql中限制m stu limit 3 select * from stu limit 3,2
--排序 select * from stu order by sid asc
--模糊查找 select * from stu where sname like '
