My SQL 프로시저 생성 방법DELIMITER //DROP PROCEDURE IF EXISTS sp_UserInfo_Select_All //CREATE PROCEDURE sp_UserInfo_Select_All( )BEGIN SELECT * FROM UserInfo;END//DELIMITER ; DELIMITER //DROP PROCEDURE IF EXISTS sp_UserInfo_Select //CREATE PROCEDURE sp_UserInfo_Select( pi_UserID INT)BEGIN SELECT * FROM UserInfo WHERE UserID = pi_UserID; END//DELIMITER ; DELIMITER //DROP PROCEDURE IF EXISTS sp_UserInfo_I..
Blog is powered by kakao / Designed by 미스터짱