create procedure count_page(p_code char(2))
define v_num integer;
select count(num) into v_num from counter where visit_date=current;
if(v_num > 0) then{
update counter set num = num+1
where visit_date=current and code=p_code;
}else{
insert into counter(p_code,visit_date,num)
values(p_code,current,1);
}
end if
end procedure;
execute procedure count_page('11');
위처럼 했는데요..
정상적인 작동이안되네요.
어디가문제인지.. 첨만들어본 프로시져인데, 도움 부탁드립니다.
테이블은..
create table counter(
p_code char(2),
visit_date date,
num integer
);
|