What you want to do is add a column that can be used to sort the rows in the table. For example, you could have a table that has two columns: msg (blob) and dt (timestamp).

You can set where auto-increment starts. I believe it works in MySQL 4.1; I don't see why it wouldn't (but I hope you have a really good reason for sticking to 4.1).<BR><BR>ALTER TABLE tablename ...

Notes High Sierra: How to add a column to a table. Click anywhere in the column next to where you want the new column to appear. It can be to the left or right of where you want the new column.