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?
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
