declare wish_cnt1 int default 0;
declare wish_cnt2 int default 0;
declare wish_cnt3 int default 0;
declare m_wishcol varchar(14);
declare m_wish int default 0;
declare reomm_cnt1 int default 0;
declare reomm_cnt2 int default 0;
declare reomm_cnt3 int default 0;
declare m_reommcol varchar(14);
declare m_reomm int default 0;
declare adver_cnt1 int default 0;
declare adver_cnt2 int default 0;
declare adver_cnt3 int default 0;
declare m_advercol varchar(14);
declare m_adver int default 0;
declare cursor_link CURSOR FOR SELECT date_format(gou_wdate,'%Y%m%d%H%i%S') gou_wdate FROM goods_url WHERE gou_codi_gcseq = seq and gou_type='codi' and gou_wdate > f_dategubun(day3,'-');
declare continue handler for not found set m_link:=1;
위 형식으로 2개 이상을 사용할 수 없나요?
|