13 lines
703 B
SQL
13 lines
703 B
SQL
update testdb.tingchequ a set a.站点地址 = SUBSTRING_INDEX(a.站点地址,'至',1) WHERE 经度 IS NULL OR 纬度 IS NULL
|
|
|
|
update testdb.tingchequ a set a.站点地址 = '蟠龙枢纽站' WHERE 经度 IS NULL and 纬度 IS null and 站点地址 = '--3'
|
|
|
|
|
|
insert ignore INTO testdb.tingchequ(骑行站点ID, 站点地址)
|
|
select c.骑行站点ID,replace(c.站点地址,'null','') 站点地址 from
|
|
(select a.骑行开始站点ID as 骑行站点ID,a.骑行开始站点 as 站点地址 FROM testdb.bike2025 a
|
|
UNION
|
|
select b.骑行结束站点ID as 骑行站点ID,b.骑行结束站点 as 站点地址 FROM testdb.bike2025 b) c
|
|
|
|
|
|
SELECT * FROM testdb.tingchequ WHERE 经度 IS NULL OR 纬度 IS NULL |