Fai wrote:
>
> According to MySQL rule, the column matching order in mysql database should be as
>following:
> +--------------------+-----+-
> | Host | user|
> +--------------------+---- +-
> |localhost| |root ||localhost| | ||pit.sample.com |root
>||pit.sample.com | ||%.snake.net |fred |+--------------------+-----+-
> However, when I issue the query "select host, user from user;" in mysql, it shows as
>the following:
> +--------------------+-----+-
> | Host | user|
> +--------------------+---- +-
> |%.sample.com |fred ||localhost | ||localhost |root
>||pit.sample.com | ||pit.sample.com |root |+--------------------+-----+-
> Can anybody tell me why? Thank you very much!
There is no defined "order" to the records in a table.
The only order is the order imposed by the query that retrieves them.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php