Jump to content

Archived

This topic is now archived and is closed to further replies.

minavio

Inserting before the first entry

Recommended Posts

How do you issue an insert statement that will insert the entry to the beginning of the table, before all the other entries, each time?

 

Any help would be greatly appreciated, thanks.

Share this post


Link to post
Share on other sites

What I mean is, when I run a

 

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.

Share this post


Link to post
Share on other sites

if u deleted some records, the data file will contain a \'hole\'. If u insert a new record mysql will re-use these \'holes\'. So you have no chance to get control over this behaviour \'til you take the source and build the engine new.

 

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...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.