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
image.png








网友评论