MariaDB [phpipam]> describe locations;
+---------------------------+---------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field                     | Type                                                                                                                      | Null | Key | Default | Extra          |
+---------------------------+---------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| id                        | int(11) unsigned                                                                                                          | NO   | PRI | NULL    | auto_increment |
| name                      | varchar(128)                                                                                                              | NO   |     |         |                |
| description               | text                                                                                                                      | YES  |     | NULL    |                |
| lat                       | varchar(12)                                                                                                               | YES  |     | NULL    |                |
| long                      | varchar(12)                                                                                                               | YES  |     | NULL    |                |
| address                   | varchar(128)                                                                                                              | YES  |     | NULL    |                |



MariaDB [phpipam]> describe locations lat;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| lat   | varchar(12) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)


MariaDB [phpipam]> describe locations long;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'long' at line 1