mysql存储过程创建项目编号实操
CREATE DEFINER=`root`@`%` PROCEDURE `getProjectCode`(out result varchar(64))BEGIN DECLARE dateStr varchar(10); DECLARE maxNo varchar(3); DECLARE count int(4);-- DECLARE count1 int(3);-- DECLARE count2 int(3);-- DECLARE projectCode1 VARC