Inserting before the first entry
Posted 19 March 2003 - 04:33 PM
Any help would be greatly appreciated, thanks.
Posted 19 March 2003 - 07:19 PM
mysql_query (\"INSERT INTO ...
command, it will sometimes append the new entry at the end of the table, sometimes at the beginning, sometimes in the middle... I don\'t know how to tell it to always insert the entry at the beginning of the table.
Posted 20 March 2003 - 07:55 AM
But how do you check for the order? A select-statement doesn\'t say anything about the physically order in the files; it\'s just in which order mysql proceeds the records...
By the way: in most databases there\'s a possibility to defrag & re-organize your tables. But in this case, the new records will find a place at the end of the data file...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users