mysql:
select * from table order by id DESC limit 1
oracle:
select * from emp where id in (select max(id) from emp);
实例:
mysql> use weifeng;
Database changed
mysql> select * from tb_post order by id desc limit 10 \G;
*************************** 1. row ***************************
id: 24897419
bloggerId: 287172
likeNum: 52
postTime: 2016-03-24 16:01:07
spiderFetchTime: NULL
postRank: NULL
showId: NULL
platformId: 1
postPlatformId: 1_b1d88acb5e5a21ed70785c41f3d5fe25
sourcePostId: NULL
mediaUrl: https://weifeng-hangzhou.aliyuncs.com/data_infra/ins/5d846f9ff66cf46ebbe115f91892bb08.jpg
width: 1080
height: 809
fileSize: 245829
averageHue: 0x4f4838
mediaType: 0
textContent: Senior Camp 2016?
postUrl: https://www.instagram.com/p/BDVAwpSksNi
orderNum: 0
postTag: NULL
videoUrl: NULL
favoriteCount: 0
status: 1
accessStatus: 8
created_at: 2018-09-19 04:12:30
updated_at: 2018-09-19 04:12:30
deleted_at: NULL
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)