mysql语句添加索引
1、为已有表添加索引： ALTER TABLE `table_name` ADD INDEX `index_name` (`column_1`, `column_2`, ...); 2、为已有表添加唯一索引
188
0
0
0
1、为已有表添加索引： ALTER TABLE `table_name` ADD INDEX `index_name` (`column_1`, `column_2`, ...); 2、为已有表添加唯一索引
1、减少不必要的数据库操作：尽量将多次查询合并成一次查询，使用存储过程，将多次查询合并成一次查询，减少数据库的操作次数。 2、优化SQL语句：可以在SQL语句中使用表的别名，加快查询速度；使用EXPLAIN关键
``` SELECT a.name,a.chinese,a.math,a.english, (SELECT COUNT(*) FROM Table b WHERE b.chinese > a.ch
SELECT stu_no,stu_name FROM student WHERE stu_no IN (SELECT stu_no FROM course_stu WHERE course_no = 01 I
SELECT stu_no FROM student_course WHERE course_no IN (SELECT course_no FROM student_course WHERE stu_no=01
centos定时备份mysql数据库并删除过期的（自己设定）备份 新建 mysql_autobackup.sh脚本，内容如下 ``` #!/bin/bash /usr/bin/mysqldump -uus
SELECT teacher,AVG(score) AS avg_score FROM course GROUP BY teacher ORDER BY avg_score DESC;
``` select stu_id,stu_name,AVG(score) from student inner join score on student.stu_id=score.stu_id where sco
``` SELECT s.name AS 姓名, c.name AS 课程名称, s.score AS 成绩, AVG(s.score) AS 平均成绩 FROM student s, course c WHERE
： SELECT course_name, COUNT(*) AS students_number FROM course_registration GROUP BY course_name;
``` SELECT * FROM SCORE ORDER BY SUBJECT, SCORE DESC LIMIT 3; ```
``` SELECT student_name,AVG(grade) as avg_grade,(SELECT COUNT(DISTINCT(AVG(grade))) FROM student_grade WHERE
SELECT SUM(CASE WHEN sex=男 THEN 1 ELSE 0 END) AS 男生人数, SUM(CASE WHEN sex=女 THEN 1 ELSE 0 END) AS 女生人数 F
select student.name, course.name, score.score from student inner join score on score.student_id=student.