编写存储过程实现插入员工表,利用存储过程在员工表中插入记录。
DELIMITER $$
CREAt
PROCEDURE `staff`.`insert_employee`( IN id INT, IN userName VARCHAR(255), IN email VARCHAR IN avatar BLOB, BEGIN
INSERT INTO `employee` VALUES(NULL,userName,birthDate,idCard,loginName,PASSWORD,mobile,email,deptId,LEVEL,avatar,remark);
END$$
DELIMITER ;
CALL `insert_employee`(NULL,'aa','2001-1-1','41032222222222222','abc','1234','123445555','123@qq.com',1,1,NULL,NULL);