Page 1 of 1

please... for oid

Posted: Wed Feb 04, 2004 8:16 pm
by josefwphil
guys we know that in order to get the newest record in the database using PostgreSQL is followed by this SQL command:

select max(oid) from <table_name>;


Guys in MySQL what is the SQL command equivalent to the above statement? Please!


:lol:

Posted: Thu Feb 05, 2004 2:20 am
by kettle_drum
Its exactly the same. If you have just inserted the record you can always use mysql_insert_id().