本页的SQL例全部懂了,你的数据库开发所需知识就够用了.doc

本页的SQL例句全部懂了，你的数据库开发所需知识就够用了 Posted on 2011-11-25 23:18 moss_tan_jun 阅读(593) 评论(1) 编辑 收藏 --====================简单的查增删改=学云网-天轰穿-[url][/url]===========--查看学生表的全部数据select * from studio? ?--插入一个新的学生信息insert into studio(st_name,st_sex,st_age,st_add,st_tel) values(黄兰淇,0,36,南充--查看class全部数据select * from class--向class表增加两条条数据insert into class(cl_class,cl_coding,cl_o_time,cl_remark) values(新电实训班,GXA-ncs-001,2008-03-11,都是很优秀的朋友)insert into class(cl_class,cl_coding,cl_o_time) values(阿坝师专实训班,GXA-ABSZ-001,2008-03-11)--更新一条的数据? ?条件的重要性update class set cl_remark=真的是不错 where cl_id=5--删除一条数据? ?条件的重要性delete from class where cl_id=7--修改列标题select cl_id as 班级主键,cl_class as 班级名称 from classselect 名字=st_name from studio--使用文字串select 名字是：,st_name from studio--=============条件稍微复杂点的查增删改==学云网-天轰穿-[url][/url]============--主要涉及到 or and not between in like?? = ! ! != () = =??is null??is not null--查询cl_id 大于 1 的所有信息select * from class where cl_id1--使用 orselect * from class where cl_id10 or cl_class=百杰一班--使用andselect * from class where cl_id10 and cl_class=百杰一班--使用like 和 %select * from class where cl_class like 百杰%select * from class where cl_remark like %上午%--使用 betweenselect * from class where cl_id between 3 and 5--使用 between 配合上 notselect * from class where cl_id not between 3 and 5--使用 is not nullselect * from class where cl_remark is not null--使用 in?select * from class where cl_class in(千星一班,百杰二班)--=================使用数学运算符=学云网-天轰穿-[url][/url]=====================--主要涉及到 + = * \--查询Java相关课程分别要上多少周??按照每周5天，每天6节课来计算select 结果=co_num/5/6 from course where co_name in (Java基础,Java项目入门)--==================使用汇总函数 ===学云网-天轰穿-[url][/url]=====================--涉及到COUNT SUM AVG MAX MIN--查询课时数小于50的课程一共有多少门select count(*) from course where co_num50--查询所有课程一共多少课时select sum(co_num) from course--计算全部课时费，假设每节课50块钱select sum(co_num)*50 from course--查询课时最少的课程select min(co_num) from course--查询课时最多的课程select max(co_num) from c