A. DELIMITER // B. CREATE PROCEDURE CountProc1(IN s_gender VARCHAR(50),OUT num INT)BEGIN C. SELECT COUNT(*) INTO num FROM student WHERE gender = s_gender;END // DELIMITER
A. DECLARE @num; CALL CountProc1(in "女",out @num); B. SET @num; CALL CountProc1("女",@num); C. DECLARE @num; DECLARE CountProc1("女",out @num); DECLARE @num; CALL CountProc1("女",@num);
A. CREATE PROCEDURE Myproc () BEGIN SELECT * FROM student; END; B. CREATE PROCEDURE Myproc () { SELECT * FROM student; }; CREATE PROCEDURE Myproc [] BEGIN SELECT * FROM student; END; D. CREATE PROCEDURE Myproc { SELECT * FROM student; };
A. DEFINER B. READER C. WRITER D. INVOKER
A. SHOW PROCEDURE STATUS B. SHOW CREATE PROCEDURE C. SHOW CREATE TABLE D. SHOW FUNCTION STATUS
微信支付 
支付宝支付