由于查出来,序号不是从1开始排列
(这里主键自增,如果其中插入失败,那么导致id序号不是从1开始排列)
解决方法:
set @i=0;
SELECT (@i:=@i+1) as '序号',
usr.nickname as '用户昵称',
product.`name` as '商品名称',
ordertemp.createTime as '创建时间',ordertemp.money as '消耗金额',ordertemp.integral as '消耗积分'
from ordertemp
LEFT JOIN usr
ON ordertemp.usrEmail=usr.email
LEFT JOIN product
ON product.id= ordertemp.productId