SQL
AD_LI
成功不必在我,而功力必不唐捐。
展开
-
Careate a view of average score.创建平均分视图
假定数据库中有三张表,student,sc,course,分别存有学生ID,学生名字;学生ID,课程ID,课程成绩;课程课程名称,现在要求求得每个学生的平均分,并创建视图,SQL代码如下: create view Average asselect student.Name,AVG(sc.grade) AS Averagefrom student,sc,coursewhere stude原创 2007-09-21 17:36:00 · 2015 阅读 · 0 评论 -
MySQL 忘记密码怎么办
在windows下:打开命令行窗口,停止mysql服务:net stop mysql启动mysql,一般到mysql的安装路径,找到 mysqld-nt.exe执行:mysqld-nt --skip-grant-tables另外打开一个命令行窗口,执行mysql>use mysql>update user set password=password("new_pass") where user原创 2007-09-21 16:45:00 · 861 阅读 · 0 评论 -
Get the average socre of the student.(The exmaple of group, having and order by).求学生平均分(group, having 和 order by使用示例).
假定数据库中有三张表,student,sc,course,分别存有学生ID,学生名字;学生ID,课程ID,课程成绩;课程课程名称,现在要求求得每个学生的平均分,并筛选平均分大于80的学生并排序,SQL代码如下: select student.Name,AVG(sc.grade) as Averagefrom student,sc,coursewhere student.ID = sc.ID原创 2007-09-21 17:34:00 · 844 阅读 · 0 评论 -
AUTO INCREMENT Reset
AUTO_INCREMENT values will be reused if you delete the row with the biggest AUTO_INCREMENT value in any group. So,empty the table if you want to count from 1 again on a column with AUTO_INCREMENT valu原创 2007-09-21 16:41:00 · 584 阅读 · 0 评论 -
【SQLSERVER】存储过程基础
1.声明变量 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->DECLARE @F001 SMALLINT, @F002 INTEGER, @F003 VARCHAR(20),转载 2007-11-25 22:58:00 · 654 阅读 · 0 评论