That is interesting to know. I have never used MySQL and automatically assigned ID's do not work that way in any of the DBMS that I have used. Those include Oracle 8i, SQL Server and Sybase.
Originally posted by kyank
Note that the automatically assigned ID is not a reliable way to identify the most recently inserted article. If you delete an older article, for example, the next new article to be added will (depending on the version of MySQL you are using) take over its ID, rather than being assigned a new, higher ID that all other entries in the table.
If you want to be able to sort entries by their insertion date, you'll have to store that date in a column of the table.
[Edited by kyank on 09-06-2000 at 10:29 PM]