C# Mysql 查询 Rownum的解决方法
Sql： 复制代码 代码如下: SELECT @rownum:=@rownum+1 AS rownum, a.order_id , case when a.Ordered =1 then '已分单' end as Ordered, a.printed , a.order_sn , a.user_id , b.user_name , a.consignee , a.tel , a.mobile , a.address , a.pa
Sql：
复制代码 代码如下:SELECT @rownum:=@rownum+1 AS rownum,a.order_id ,case when a.Ordered =1 then '已分单' end as Ordered,a.printed ,a.order_sn ,a.user_id ,b.user_name ,a.consignee ,a.tel ,a.mobile ,a.address ,a.pay_name ,a.goods_amount ,a.shipping_fee ,FROM_UNIXTIME(a.add_time+8*3600) ,a.postscript ,a.best_timeFROM (SELECT @rownum:=0) r,xj_order_info a INNER JOIN xj_users b on a.user_id =b.user_idwhere (order_status ='1') and (FROM_UNIXTIME(a.add_time) between '{0}' and '{1}')ORDER BY rownum asc
sql语句在Navicat中查询没有问题，但在程序中各种报错。
尝试过将@改为？，也尝试过传参的方法，但都不成功。
最后，还是在StackOverflow中找到了解决方案：
Allow User Variables=True；
问题成功解决。
