Home >Database >Mysql Tutorial >select-用MySql的Navicat创建存储过程总是报1458错误
select-用MySql的Navicat创建存储过程总是报1458错误
- WBOYOriginal
- 2016-06-06 09:40:262143browse
selectmysql存储过程
下面是我穿件存储过程的代码。求大神帮忙看看。真心很急，明天就要用。
<code> create procedure searchStudentGrade(in id char) begin if id is null select student.StudentID,student.StudentName,student.ClassNumber,grade.ExamID,course.CourseName,grade.Grade,course.CourseID from student,grade,course where student.StudentID=grade.StudentID and grade.CourseID=course.CourseID; else select student.StudentID,student.StudentName,student.ClassNumber,grade.ExamID,course.CourseName,grade.Grade,course.CourseID from student,grade,course where student.StudentID=grade.StudentID and grade.CourseID=course.CourseID and grade.StudentID=id; end if;end;</code>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：ubuntu-Ubuntu上安装mysql的问题Next article：select-mysql中如何在查询所有字段的同时对其中一字段进行转换