MySQL复习笔记二

警告
本文最后更新于 2019-06-03,文中内容可能已过时。

MySQL复习笔记一: http://www.yqqy.top/notes/311

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
DELIMITER //
CREATE PROCEDURE p_stu1(IN
	student_name char(10),IN
	course_name char(20))
BEGIN
	SELECT Sname, Cname, Grade
	FROM xs s JOIN xk ON s.sno = xk.sno
	INNER JOIN kc c ON c.cno = xk.cno
	WHERE sname = student_name
	AND cname = course_name;
END //
DELIMITER;

https://pic.yqqy.top/blog/20200111/uNYFhQTsm6j5.png

call p_stu1("zhangsan", "mysql");

https://pic.yqqy.top/blog/20200111/jNIFq3jhSLtX.png

CREATE USER 'yqchilde' @ '%' IDENTFIND BY PASSWORD 'root'