please... for oid

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
josefwphil
Forum Newbie
Posts: 1
Joined: Wed Feb 04, 2004 8:16 pm
Location: philippines
Contact:

please... for oid

Post 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:
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

Its exactly the same. If you have just inserted the record you can always use mysql_insert_id().
Post Reply