Hans, > I use it as a temporary file. Putting data in it sequential and after that > reading it out sequential. I don't want a auto increment field or > whatsoever because I want the date in sequential order of the data... the > data itself cannot (always) be used as a primary key
If you don't have a "sequence" number of some kind, why do you expect the data to be "sequential". I'm not sure about MySQL, but from other systems I know, that if you don't specify an ORDER BY clause (in your case: order by sequential_number), the order in which the data is returned is "implementation defined". This can be one of the following: 1) according to a primary or clustered index 2) in whatever order the rows are stored on disk Usually, it's 2. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
