MySQL Sample Procedure
1.Create a Procedure DELIMITER $$ DROP PROCEDURE IF EXISTS `new_drive` $$ CREATE PROCEDURE `new_drive` (IN my_emp_num VARCHAR(30), IN my_truck_num VARCHAR(30), IN my_drive_date VARCHAR(30)) BEGIN IF EXISTS (SELECT * FROM employee WHERE emp_num = my_emp_num) THEN SELECT ‘The Employee is already Existed’; ELSE IF EXISTS (SELECT… Read More