Base MYSQL Database create stored procedures resolve the Delimiter error

合集 - C#(3)

1.Base MYSQL Database create stored procedures resolve the Delimiter error2024-02-22

2.2层for循环生成 TreeView2024-02-283.向TreeView添加自定义信息2024-03-07

收起

Base MYSQL Database create stored procedures resolve the Delimiter error, It must be created using a query script. You can't use the Create Procedure Wizard directly.
for example:
Delimiter $$ CREATE PROCEDUREPR_SELSTATION( in Sname varchar(50), in Scode varchar(50) ) BEGIN if Sname='' and Scode <> '' then Begin SELECT NUM_STN ,NAME_STN ,SHORTNAME_STN ,IDEOBJ_STN ,IDENO_STN ,THISFLAG_STN ,QUICKKEY_STN ,STNO_STN ,(Select VALUE_PARAV From TB_SYS_PARAV Where NUM_PARAV=STASPECT_STN) as dierction_STN FROM TB_SYS_STATION WHERE NUM_STN LIKE concat('%',Scode,'%'); end; end if; if Scode='' and Sname <> '' then Begin SELECT NUM_STN ,NAME_STN ,SHORTNAME_STN ,IDEOBJ_STN ,IDENO_STN ,THISFLAG_STN ,QUICKKEY_STN ,STNO_STN ,(Select VALUE_PARAV From TB_SYS_PARAV Where NUM_PARAV=STASPECT_STN) as dierction_STN FROM TB_SYS_STATION WHERE NAME_STN LIKE concat('%',Sname,'%'); END; end if; if Sname<>'' And Scode<>'' then Begin SELECT NUM_STN ,NAME_STN ,SHORTNAME_STN ,IDEOBJ_STN ,IDENO_STN ,THISFLAG_STN ,QUICKKEY_STN ,STNO_STN ,(Select VALUE_PARAV From TB_SYS_PARAV Where NUM_PARAV=STASPECT_STN) as dierction_STN FROM TB_SYS_STATION WHERE NAME_STN LIKE concat('%',Sname,'%') And NUM_STN LIKE concat('%',Scode,'%'); End; end if; END$$