CREATE DEFINER=`root`@`localhost` PROCEDURE `get_emp_info`() BEGIN select * from employee; END call get_emp_info;