Paul,
Thanks for the explanation!
Best Regards,
Viktor Vasiliou
- Original Message -
From: Paul DuBois
To: Viktor Vasiliou ; [EMAIL PROTECTED]
Sent: Friday, February 14, 2003 12:05 AM
Subject: Re: Re: Strange sorting in table
At 0:01 +0100 2/14/03, Viktor Vasiliou wrote:
>Ok
At 0:01 +0100 2/14/03, Viktor Vasiliou wrote:
Ok, I guess you're right. It's just that it has never happend to me before.
Thanks for your help.
In general, when you simply insert rows into a table, that's the order
in which they're returned. That's just happy coincidence, and not
to be relied o
Ok, I guess you're right. It's just that it has never happend to me before.
Thanks for your help.
Regards,
Viktor
- Original Message -
From: Paul DuBois
To: [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 11:48 PM
Subject: Re: Re: Strange sorting in table
>St
Stefan and Paul,
When adding ORDER BY counterid, all rows are sorted correctly, but
it should not be needed. All the other tables are sorted correctly
at the start, and has always been.
I'm not sure where you got that idea. There is NO guarantee about the
order in which rows are returned unless
, 2003 10:23 PM
Subject: Re: Strange sorting in table
At 19:55 +0100 2/13/03, Viktor Vasiliou wrote:
>Hi Stefan,
>
>Thanks for your reply!
>
>The table has just been created, and has therefore no deleted
>entries. ID 1-1000 was created by myself, ID 1002 was created when a
&g
4 PM
Subject: Re: Strange sorting in table
Viktor,
I have a couple of tables in a MySQL database. In one of the tables,
PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and
ID 22. Any idea why?
Have a look at the table structure. You will find 'ID' is an
AUTO_INCREME
al Message -
From: Stefan Hinz
To: Viktor Vasiliou
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 12, 2003 3:34 PM
Subject: Re: Strange sorting in table
Viktor,
> I have a couple of tables in a MySQL database. In one of the tables,
> PhpMyAdmin sorts very strange. ID 1002 is places betwee
Viktor,
> I have a couple of tables in a MySQL database. In one of the tables,
> PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and
> ID 22. Any idea why?
Have a look at the table structure. You will find 'ID' is an
AUTO_INCREMENT column. When entries are deleted, they leave "gaps
