select st_srid(geom) from f_base_facility -- 查看mysql空间坐标系 update t_road set geom= geomfromtext(st_astext(geom),4326);