1. 查看该数据库实例下所有库大小，得到的结果是以MB为单位mysql>selecttable_schema,sum(data_length)/1024/1024asdata_length,sum(index_len
2021-12-07 14:34
147
0
0
0
Student(S#,Sname,Sage,Ssex) 学生表Course(C#,Cname,T#) 课程表SC(S#,C#,score) 成绩表Teacher(T#,Tname) 教师表问题：1、查询“001”课程
2021-12-07 14:35
147
1
1
0
asp连接mysql代码
asp连接mysql之前须安装aMyODB
下载地址
http://www.skycn.com/soft/2141.html
一般中文都会乱码
乱码解决方法
conn.E
2021-12-07 14:44
147
1
1
0
SELECT stu_no FROM student_course WHERE course_no IN (SELECT course_no FROM student_course WHERE stu_no=01
2023-07-10 09:03
148
0
0
0
```
SELECT s.name AS 姓名, c.name AS 课程名称, s.score AS 成绩, AVG(s.score) AS 平均成绩
FROM student s, course c
WHERE
2023-07-11 10:49
148
0
0
0
1、减少不必要的数据库操作：尽量将多次查询合并成一次查询，使用存储过程，将多次查询合并成一次查询，减少数据库的操作次数。
2、优化SQL语句：可以在SQL语句中使用表的别名，加快查询速度；使用EXPLAIN关键
2023-07-07 09:21
148
0
0
0
SELECT stu_num, stu_name FROM student WHERE stu_num IN (SELECT stu_num FROM student WHERE stu_num != 01 IN
2023-06-20 09:33
149
0
0
0
```
SELECT stu_name,score_sum,
@curRank := @curRank + 1 AS rank
FROM student,(SELECT @curRank := 0) r
ORDE
2023-07-11 10:51
149
0
0
0