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

怼烎@ 2023-01-11 13:15 193阅读 0赞

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 ;