Re: Cacti - Centos 7 - MYSQL Table ORDER BY issue

[Brad Morton]

When I run this command on the SITES table, its clear that the table is being ordered via the ID and not the NAME

MariaDB [cacti]> select * FROM sites;
+----+--------------------+---------------------+----------+----------------+---------+-------------+---------+-----------------+---------------+----------------+--------------+-------+
| id | name | address1 | address2 | city | state | postal_code | country | timezone | latitude | longitude | alternate_id | notes |
+----+--------------------+---------------------+----------+----------------+---------+-------------+---------+-----------------+---------------+----------------+--------------+-------+
| 1 | !--DC--! | 123 Here St. | | My Town | Ontario | H0H 0H0 | Canada | America/Toronto | 44.2250480000 | -76.4819320000 | | |
| 2 | CCL-KEMPTVILLE-O | 123 There St.. | | Your Town | Ontario | H0H 0H0 | Canada | America/Toronto | 44.9794530000 | -75.6208080000 | | |
| 3 | CCL-DALTON-O | 123 NoWhere St. | | This Town | Ontario | H0H 0H0 | Canada | America/Toronto