Sql:
Copy Code code as follows:
SELECT
@rownum: = @rownum +1 as rownum,
A.ORDER_ID,
Case when a.ordered =1 then ' has been divided into single ' 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_time
From (SELECT @rownum: =0) r,xj_order_info a INNER JOIN xj_users b on a.user_id =b.user_id
WHERE (Order_status = ' 1 ') and (From_unixtime (a.add_time) between ' {0} ' and ' {1} ')
ORDER BY rownum ASC
SQL statements have no problem querying in navicat, but there are various errors in the program.
Tried to change @ to? , the method of passing the parameter was also attempted, but was unsuccessful.
Finally, a solution was found in the StackOverflow:
Allow User variables=true;
Problem solved successfully.