← Back to team overview

drizzle-discuss team 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
like

1) getting max valued row:
select * from table ,
(select max(value) from table ) as t
table.value=t.value

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.
 like :
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?

Follow ups