mysql-procedure generateTaxDoc

mysql-routine  generateTaxDoc

delimiter $$
drop procedure generateTaxDoc $$
CREATE PROCEDURE generateTaxDoc (
  P_taxDoc varchar(10), P_employeeRecordid int(20),P_employeeNumber int(20))
BEGIN
    declare mycount int(4);
    select count(*) into mycount from taxDoc where taxdoc=P_taxdoc and employeeRecordid=P_employeeRecordid;
  if (mycount=0) then
    insert into taxDoc (taxdoc,employeeRecordID) values (P_taxdoc,P_employeeRecordid);
  end if;
END;
$$
call generateTaxDoc(1,2,3) $$
select * from taxDoc $$