mysql创建更新存储过程_Mysql 创建存储过程 更新表

DELIMITER // use protocoldb// drop procedure if exists sp_protocol_Update// create procedure sp_protocol_Update ( in p_ProtocolNodeUID                               varchar(64),                         in p_VersionUID                                    varchar(64),                         in p_ParentProtocolNodeUID                      varchar(64), in p_IsDefaultSelected                          TINYINT(1), in p_SequenceOrder                              INT(11), in p_NodeType                                   CHAR(50), in p_NodeKey                                    varchar(64), in p_NodeLabel                                  varchar(200), in p_ExamedBodyPart                             varchar(200), in p_ScanTypeSupported                          CHAR(50), in p_PatientPosition                            CHAR(50), in p_PrivateProtocolFilePath                    varchar(1024), in p_Description                               varchar(1024), in p_LeftRightFlag                              CHAR(50), in p_AgeGroup                                   CHAR(50), in p_FileVersionNumber                          varchar(64), in p_ExampleFigurePath                          varchar(1024), in p_PatientTypeID                              varchar(64), in p_ProcedureID                                varchar(64), in p_PSASID                                     varchar(64), in p_ProtocolID                                 varchar(64), in p_IsFavourite                                TINYINT(1), in p_IsTimed                                    TINYINT(1), in p_IsFactoryPredefine                         TINYINT(1), in p_IsNeedInjection                            TINYINT(1), in p_IsLicensed                                 TINYINT(1), in p_IsCardicScan                               TINYINT(1), in p_IsPediatric                                TINYINT(1), in p_CreateDate                                 DATETIME, in p_CreateBy                                   varchar(64), in p_UpdateDate                                 DATETIME, in p_UpdateBy                               varchar(64) ) begin update protocolnode set VersionUID = p_VersionUID, ParentProtocolNodeUID = p_ParentProtocolNodeUID, IsDefaultSelected = p_IsDefaultSelected, SequenceOrder = p_SequenceOrder, NodeType = p_NodeType, NodeKey = p_NodeKey, NodeLabel = p_NodeLabel, ExamedBodyPart = p_ExamedBodyPart, ScanTypeSupported = p_ScanTypeSupported, PatientPosition = p_PatientPosition, PrivateProtocolFilePath = p_PrivateProtocolFilePath, Description = p_Description, LeftRightFlag = p_LeftRightFlag, AgeGroup = p_AgeGroup, FileVersionNumber = p_FileVersionNumber, ExampleFigurePath = p_ExampleFigurePath, PatientTypeID = p_PatientTypeID, ProcedureID = p_ProcedureID, PSASID = p_PSASID, ProtocolID = p_ProtocolID, IsFavourite = p_IsFavourite, IsTimed = p_IsTimed, IsFactoryPredefine = p_IsFactoryPredefine, IsNeedInjection = p_IsNeedInjection, IsLicensed = p_IsLicensed, IsCardicScan = p_IsCardicScan, IsPediatric = p_IsPediatric, CreateDate = p_CreateDate, CreateBy = p_CreateBy, UpdateDate = p_UpdateDate, UpdateBy = p_UpdateBy where ProtocolNodeUID = p_ProtocolNodeUID; end // DELIMITER ;