jf~~ 下个手册看看,挺详细的。 大体如此(供参考,具体手册+google吧) 到表格所在库 mysql>delimiter // mysql>create procedure test(out p int) mysql>begin mysql>SELECT @a:=sum(todayhit) FROM hittabel; mysql>select select number into p from numbertable where number=@a mysql>end;// mysql>delimiter ; 用时: mysql>call test(@num); mysql>select @num;
改改 mysql>select number into p from numbertable where number=@a;
下个手册看看,挺详细的。
大体如此(供参考,具体手册+google吧)
到表格所在库
mysql>delimiter //
mysql>create procedure test(out p int)
mysql>begin
mysql>SELECT @a:=sum(todayhit) FROM hittabel;
mysql>select select number into p from numbertable where number=@a
mysql>end;//
mysql>delimiter ;
用时:
mysql>call test(@num);
mysql>select @num;
mysql>select number into p from numbertable where number=@a;
不成熟...