直接执行就可以了 唯一不同的就是先要用delimiter 把结束符换掉。 delimter // create procedure getqq() beginselect * from qq; end // delimter //
现在我的问题是在 create procedure getqq(s varchar(20)) begin declare str varchar(200); set str='select * from qq where id='+s; exec(str);//这里怎么换!!! end
delimiter // create procedure getqq(ss int) begin select * from qq where a=ss; end//delimiter ; call getqq(8); +---+------+------+------+------+ | a | b | new | cc | xx | +---+------+------+------+------+ | 8 | NULL | 12 | NULL | NULL | +---+------+------+------+------+ 1 row in set (0.04 sec)
delimiter // create procedure getqq(ss int) begin select ss from qq end//这样怎么处理!!列是变量!delimiter ; call getqq(8);
另外还有这样的可能!! create procedure getqq(ss int) begin select * from qq limit ss end
drop procedure get_page ; delimiter // create procedure get_page(ppage int,psize int) beginset @ppage=ppage; set @psize=psize; set @pbegin=(@ppage-1)*psize ; set @str='select * from money order by paytime limit ?,?'; prepare smt from @str; execute smt using @pbegin,@psize; end // delimiter ;
现在我的问题是在 create procedure getqq(s varchar(20)) begin declare str varchar(200); set str='select * from qq where id='+s; exec(str);//这里怎么换!!! end----------------------- delimiter //; create procedure getqq(s varchar(20)) begin select * from qq where id='+s; end; delimiter ;//
唯一不同的就是先要用delimiter 把结束符换掉。
delimter //
create procedure getqq()
beginselect * from qq;
end
//
delimter //
create procedure getqq(s varchar(20))
begin
declare str varchar(200);
set str='select * from qq where id='+s;
exec(str);//这里怎么换!!!
end
create procedure getqq(ss int) begin select * from qq where a=ss; end//delimiter ;
call getqq(8);
+---+------+------+------+------+
| a | b | new | cc | xx |
+---+------+------+------+------+
| 8 | NULL | 12 | NULL | NULL |
+---+------+------+------+------+
1 row in set (0.04 sec)
create procedure getqq(ss int) begin select ss from qq end//这样怎么处理!!列是变量!delimiter ;
call getqq(8);
create procedure getqq(ss int) begin select * from qq limit ss end
delimiter //
create procedure get_page(ppage int,psize int)
beginset @ppage=ppage;
set @psize=psize;
set @pbegin=(@ppage-1)*psize ;
set @str='select * from money order by paytime limit ?,?';
prepare smt from @str;
execute smt using @pbegin,@psize;
end
//
delimiter ;
create procedure getqq(s varchar(20))
begin
declare str varchar(200);
set str='select * from qq where id='+s;
exec(str);//这里怎么换!!!
end-----------------------
delimiter //;
create procedure getqq(s varchar(20))
begin
select * from qq where id='+s;
end;
delimiter ;//