#数据迁移存储过程
DROP PROCEDURE IF EXISTS `delete_platform_patient`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `delete_platform_patient`()
BEGIN
declare counts integer;-- 记录迁移条数
declare date_former datetime;-- 定义一个时间变量用来存放时间
declare result_code integer; -- 定义返回结果并赋初始值
declare CONTINUE HANDLER for SQLEXCEPTION set result_code=1; -- 在执行过程中出现任何异常result_code为1
select date_sub(now(),interval 3 month) into date_former; -- 获取三个月前的时间存入定义的时间变量中
select count(1) into counts from platform_patient where create_time
start TRANSACTION;-- 进行事物处理
insert into platform_patient_historys select * from platform_patient p where p.create_time
delete from platform_patient where create_time
insert into t_yh_move_data_log (time,tablename,count) values(NOW(),'platform_patient',counts);
IF result