一、DDL與DML

CREATE TABLE student (id INT PRIMARY KEY AUTO_INCREMENT,createDate DATETIME NOT NULL,userName VARCHAR(255) NOT NULL,phone VARCHAR(20) NOT NULL,age INT NOT NULL,sex ENUM('男', '女') NOT NULL,introduce TEXT
);
INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES (NOW(), '鄒靖釗', '13800138000', 20, '男', '鄒生靖釗，風華絕代，儀表堂堂。才情橫溢，品行高潔，實乃人中龍鳳也。');
INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES (NOW(), '張三', '13900139000', 22, '男', '張三公子，英俊瀟灑，氣宇軒昂。才情出眾，志向遠大，必成大器。');INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES (NOW(), '李四', '13700137000', 19, '女', '李四姑娘，婉約秀麗，溫文爾雅。才思敏捷，慧心巧思，令人贊嘆不已。');INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES (NOW(), '王五', '13600136000', 21, '男', '王五壯士，英勇威武，氣概不凡。學富五車，胸懷壯志，必能成就一番偉業。');INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES (NOW(), '趙六', '13500135000', 23, '女', '趙六娘子，端莊嫻雅，儀態萬方。才情出眾，品德高尚，堪稱女中豪杰。');INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES (NOW(), '孫七', '13400134000', 20, '男', '孫七少年，英俊瀟灑，風度翩翩。才情橫溢，志向高遠，未來可期。');

二、創建存儲過程

-- 創建存儲過程get_student_introduce，用于查詢指定userName的學生的introduce信息
DELIMITER //
CREATE PROCEDURE get_student_introduce(IN p_userName VARCHAR(50))
BEGIN-- 聲明變量用于存儲查詢結果DECLARE v_introduce TEXT;-- 查詢指定userName的學生的introduce信息SELECT introduce INTO v_introduce FROM student WHERE userName = p_userName;-- 如果找到了匹配的記錄，則輸出其introduce信息IF v_introduce IS NOT NULL THENSELECT v_introduce;ELSE-- 如果沒有找到匹配的記錄，則輸出提示信息SELECT '沒有找到指定學生的簡介信息';END IF;
END //
DELIMITER ;CALL get_student_introduce('鄒靖釗');