qq_43789643的博客

sql原生查询（仅限参考） 1、 查询"01"课程比"02"课程成绩高的学生的信息及课程分数 Select * from (select score.s_id,score.c_id,score.s_score as 01_num,student.s_name,student.s_birth,student.s_sex from score left join student on student...

mysql存储过程 1.创建存储过程 delimiter $$ create procedure test() begin end $$ 查看存储过程 2.show procedure status\G; ================================================ 3.drop procedure +name ==存储过程 实例1 delimiter ...