行是mysql中的保留字
对文本使用记号
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
set @i = 0;
select @i := @i+1 as 'Row',Target,StartDate,EndDate
from (
select target,
StartDate,
EndDate
from t_learning_note
where 1 = 1
and target= @TargetSn
order by StartDate desc
)
COMMIT;
正如Akina指出的,这在mysql中运行,但可能会导致问题。
所以你也可以用像
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
set @i = 0;
select @i := @i+1 as `Row`,Target,StartDate,EndDate
from (
select target,
StartDate,
EndDate
from t_learning_note
where 1 = 1
and target= @TargetSn
order by StartDate desc
)
COMMIT;