mysql函数常用demo

r囧r小猫 2022-10-27 00:26 6阅读 0赞

CREATE DEFINER=`root`@`%` PROCEDURE `insert_wx_temp`(IN wx_appid VARCHAR ( 20 ),IN tem_id VARCHAR ( 100 ) ,out  out_result int(8))
    BEGIN
    		
    		########替换变量开始-------------------
    		#定义游标临时变量-------------------开始
      
        DECLARE sa_id_data int (11);
        DECLARE unit_top_id_data int  (11);
    
    		 
    		#把结果数量赋值给某个变量
    		SELECT  sa_id , unit_top_id into  sa_id_data, unit_top_id_data FROM  sys_app  WHERE  wechat_appid =  wx_appid limit 1   ;
     
    										 
    		INSERT INTO  wx_template_bak( sa_id, wechat_appid, wx_account_app_id, wx_template_id, wx_template_name, wx_column, tm_column_name, tm_column, tm_category, tm_type, tm_state, tm_order, tm_create_time, unit_top_id, unit_top_name, unit_id, unit_name) VALUES ( sa_id_data, wx_appid, NULL, tem_id, '小程序交易提醒', 'amount5', '实付金额', 'actual_money', 'GENERAL', 1, 1, 1, now(), unit_top_id_data, NULL, NULL, NULL);
    		INSERT INTO  wx_template_bak( sa_id, wechat_appid, wx_account_app_id, wx_template_id, wx_template_name, wx_column, tm_column_name, tm_column, tm_category, tm_type, tm_state, tm_order, tm_create_time, unit_top_id, unit_top_name, unit_id, unit_name) VALUES ( sa_id_data, wx_appid, NULL, tem_id, '小程序交易提醒', 'phrase4', '交易类型', 'trade_type', 'GENERAL', 1, 1, 2, now(), unit_top_id_data, NULL, NULL, NULL);
    		INSERT INTO  wx_template_bak( sa_id, wechat_appid, wx_account_app_id, wx_template_id, wx_template_name, wx_column, tm_column_name, tm_column, tm_category, tm_type, tm_state, tm_order, tm_create_time, unit_top_id, unit_top_name, unit_id, unit_name) VALUES ( sa_id_data, wx_appid, NULL, tem_id, '小程序交易提醒', 'thing2', '加油站|余额', 'unit_name|balance', 'GENERAL', 1, 1, 3, now(), unit_top_id_data, NULL, NULL, NULL);
    		INSERT INTO  wx_template_bak( sa_id, wechat_appid, wx_account_app_id, wx_template_id, wx_template_name, wx_column, tm_column_name, tm_column, tm_category, tm_type, tm_state, tm_order, tm_create_time, unit_top_id, unit_top_name, unit_id, unit_name) VALUES ( sa_id_data, wx_appid, NULL, tem_id, '小程序交易提醒', 'time3', '交易时间', 'pay_time', 'GENERAL', 1, 1, 4, now(), unit_top_id_data, NULL, NULL, NULL);
    
    		
     
     
    END