mysql查询语句 变量_mysql查询语句中用户变量的使用

先上代码吧

SELECT `notice`.`id` , `notice`.`fid` , `notice`.`has_read` , `notice`.`notice_time` , `notice`.`read_time` , `f`.`fnum` , `f`.`forg` , `f`.`fdst` , `f`.`actual_parking` AS `parking` , `f`.`scheduled_deptime` , `f`.`estimated_deptime` , `f`.`actual_deptime` , `f`.`scheduled_arrtime` , `f`.`estimated_arrtime` , `f`.`actual_arrtime` , `f`.`is_vip` , `f`.`aoc_notice`

FROM (

select

t.id,

t.fid,

t.has_read,

t.notice_time,

t.read_time

from

(

select

a.id,

a.fid,

a.has_read,

a.notice_time,

a.read_time,

@v_rownum := @