数据库查询语句,急!!!
发布网友
发布时间：2022-06-13 17:40
共1个回答
热心网友
时间：2023-10-14 19:56
(@rowNumB:=@rowNumB+1) AS row_number,
(@rowNumC:=(@rowNumB*3+1.1)) AS display_order
这连个自定义的列交换一下位置就可以了
SELECT
'' AS place_uuid,
'' AS consumption_point_uuid,
'' AS consumption_point_name,
FALSE AS shared,
'' AS merchant_logo,
'' AS merchant_background,
'' AS district,
'' AS user_point,
TRUE AS offer_banner,
`PHOTO_PATH` AS offer_banner_photo,
`LINK` AS offer_banner_link,
(@rowNumC:=(@rowNumB*3+1.1)) AS display_order,
(@rowNumB:=@rowNumB+1) AS row_number,
FROM `BIZ_OFFER_BANNER`,
(SELECT (@rowNumB:=0) ) b,
(SELECT (@rowNumC:=1) ) c
) t
ORDER BY t.display_order
