Re: Sort Table
| From: | Rasmus Lerdorf | Date: | Fri, 11 Apr 2003 20:05:18 +0000 |
| Subject: | Re: Sort Table | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19396@lists.php.net to get a copy of this message | ||
You apply order when you select data out of the table, never on insert.
As in: select * from foo order by key_name desc
-Rasmus
On Fri, 11 Apr 2003 Trystano@aol.com wrote:
> I have a table in MySQL that contains list of entries and when I delete an
> entry and then insert another entry, the entry I just inserted gets placed in
> the position where the last entry got deleted instead of at the bottom of the
> table.
>
> Is there a way I can sort the table by its primary key??
>
> Tryst
>
>