create procedure rkb ( i int, x varchar, y varchar, j text ) begin set i =0;select id,i:=i+1 as order_id,packageno,x,y,lotno,count(lotno),j as intro from barcode_rk where packageno='CVT111011001' or packageno='CVT111011002' group by packageno;end; 执行不成功。
mysql帐户没问题,但是mysql_query不支持set用法。
请问php的mysql_query()函数怎么执行顶楼的sql代码?
mysql_query要分开执行,按;那是两个SQL语句
mysql_query("set @i=0"); $rs = mysql_query("select id,@i:=@i+1 as order_id,packageno,@x,@y,lotno,count(lotno),@j as intro from barcode_rk where packageno='CVT111011001' or packageno='CVT111011002' group by packageno");
(
i int,
x varchar,
y varchar,
j text
)
begin
set i =0;select id,i:=i+1 as order_id,packageno,x,y,lotno,count(lotno),j as intro from barcode_rk where packageno='CVT111011001' or packageno='CVT111011002' group by packageno;end; 执行不成功。
mysql帐户没问题,但是mysql_query不支持set用法。
$rs = mysql_query("select id,@i:=@i+1 as order_id,packageno,@x,@y,lotno,count(lotno),@j as intro from barcode_rk where packageno='CVT111011001' or packageno='CVT111011002' group by packageno");