#参数分为“IN、OUT、INOUT”，IN是输入参数，在存储过程中不可修改，OUT是输出参数，INOUT是输入输出参数CREATE DEFINER=`sa`@`192.168.1.8%` PROCEDURE `p_materialPlanChange`(IN `p_projectId` varchar(32), IN `p_applicantAccount` varchar(20), OUT

表A 字段：id, name, sex...表B字段：id, name. sex...update A a, B bset  a.name=b.name,a.sex=b.sexwhere a.id = b.id;

create temporary table if not exists temp_procurement(id char(32) NOT NULL,currentStep varchar(16) default NULL,currentStepID char(32) default NULL,currentStepTime varchar(19) default NULL,p