本人有一个叫 location的表 我要去其中的 adress 这个列的最新 数据 ,里面有个 time 列记录时间
这样可以吗 ?SELECT a.address from location a ORDER BY a.time DESC
SELECT a.address from location a ORDER BY a.time DESC limit 1 这个是结果集SELECT a.address into @address from location a ORDER BY a.time DESC limit 1; select @address 是结果
你就取time列的最新,是吧 select max(a.address) from location
select * from tb order by time desc,id desc limit 1
select * from location order by time desc limit 1;
这个是结果集SELECT a.address into @address from location a ORDER BY a.time DESC limit 1;
select @address
是结果
select max(a.address) from location
select * from tb order by time desc,id desc limit 1