#查询最新的一条记录
SELECT * from asset_server WHERE public_ip=‘127.0.0.1’ ORDER BY update_time desc limit 1;
其中asc是和desc相反,是升序,从小到大排序,
#查询最旧的一条记录
SELECT * from asset_server WHERE public_ip=‘127.0.0.1’ ORDER BY update_time asc limit 1;
#查询最新的一条记录
SELECT * from asset_server WHERE public_ip=‘127.0.0.1’ ORDER BY update_time desc limit 1;
其中asc是和desc相反,是升序,从小到大排序,
#查询最旧的一条记录
SELECT * from asset_server WHERE public_ip=‘127.0.0.1’ ORDER BY update_time asc limit 1;