desc_spatial.sql

mysql> show tables;
+-------------------+
| Tables_in_geo_loc |
+-------------------+
| geometry_columns  |
| points_new        |
| spatial_ref_sys   |
+-------------------+
3 rows in set (0,05 sec)

mysql> desc points_new;
+----------+--------------+-----+----+-------+--------------+
|Field     | Type         | Null| Key|Default|Extra         |
+----------+--------------+-----+----+-------+--------------+
|OGR_FID   | int(11)      | NO  | PRI|NULL   |auto_increment|
|SHAPE     | geometry     | NO  | MUL|NULL   |              |
|zcta5ce10 | varchar(5)   | YES |    |NULL   |              |
|geoid10   | varchar(5)   | YES |    |NULL   |              |
|classfp10 | varchar(2)   | YES |    |NULL   |              |
|mtfcc10   | varchar(5)   | YES |    |NULL   |              |
|funcstat10| varchar(1)   | YES |    |NULL   |              |
|aland10   | decimal(14,0)| YES |    |NULL   |              |
|awater10  | decimal(14,0)| YES |    |NULL   |              |
|intptlat10| varchar(11)  | YES |    |NULL   |              |
|intptlon10| varchar(12)  | YES |    |NULL   |              |
+----------+--------------+-----+----+-------+--------------+
11 rows in set (0,00 sec)