查询当前库的每个表的总条数
select table_name,table_rows from information_schema.tables
where TABLE_SCHEMA = 'szgd' order by table_rows desc;
插入一条空间数据记录
insert into test(id,lstr) values (1,GeomFromText('LINESTRING(1 -1)'));
查询一条空间数据
SELECT AsText(geom) FROM GEO_ST WHERE id='000c29a942df'