drizzle-discuss team mailing list archive
Mailing list archive
last inserted row, max row, random row methods
assume *table* has *id, value* rows
In mysql there is no special indicatior and we need to make funny things
1) getting max valued row:
select * from table ,
(select max(value) from table ) as t
2) last inserted row
select * from table order by id limit 1
3) one random row
select * from table order by rand() limit 1
I think there could faster, elegant row methods are required.
1) select maxrow(*) from table
2) select lastrow(*) from table
3)select randomrow(*) from table
My question is :
are There such methods?
if not, will there be such methods?