select * from a;
需要每一行,下面的减去上面的,得到行的时间差
select
a.* ,
time_to_sec(one.create_time) currentSecond,
@one.createTime AS previousSecond,
@one.createTime := time_to_sec(one.create_time)
from a ,(SELECT @one.createTime := 0) tmp
结果是
如果要相减的不是时间,也没有问题,去掉time_to_sec即可