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!