SELECT * FROM amap_citys
;
ALTER TABLE amap_citys
ADD INDEX index_name ( pId
)
ALTER TABLE amap_citys
ADD INDEX index_nam2 ( randomCode
)
ALTER TABLE amap_citys
ADD INDEX index_nam3 ( parentRandomCode
)
UPDATE amap_citys
as a INNER JOIN amap_citys
as b ON a.parentRandomCode=b.randomCode set a.pId=b.id

网友评论