mysqlストレージ・プロシージャ(異なるデータベース)1つのテーブルから別のテーブルにコピー

begin
	DELETE FROM test_cpos_store.t_sn_mc_market;

 --       done，             
 DECLARE done INT DEFAULT 0;
 --       ，             
 --                        ，         NULL
	DECLARE marketCode char(3);
	DECLARE financeEmail varchar(400);
  DECLARE id,barndCode,brandName,brancNameCn,brandNameEn,marketName varchar(100);
	DECLARE delSql varchar(100);
  #DELETE FROM t_sn_mc_market WHERE 1 =1 ;

 --         SQL   
 DECLARE cur CURSOR FOR select GUID,BRAND_CODE,BRAND_NAME_CN,BRAND_NAME_EN,MARKET_CODE,MARKET_NAME,FINANCE_EMAIL FROM t_sn_mc_market;
 --            done     1
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 --     
 open cur;
 --        
 REPEAT
  --                
  FETCH cur INTO id,barndCode,brancNameCn,brandNameEn,marketCode,marketName,financeEmail;
  if not done then
   --         tname， tpass       
		#if (select count(1) from hx_message_user where uid=tid) = 0 THEN
			
			INSERT INTO test_cpos_store.t_sn_mc_market(GUID,BRAND_CODE,BRAND_NAME_CN,BRAND_NAME_EN,MARKET_CODE,MARKET_NAME,FINANCE_EMAIL) VALUES(id,barndCode,brancNameCn,brandNameEn,marketCode,marketName,financeEmail);
				
		#end if;
   #select tid,tname, tpass,(select count(1) from btable where id=tid) as count;
  end if;
  UNTIL done END REPEAT;
 CLOSE cur;
end