open-platform

DELETE FROM dict_city WHERE grade=5;
DELETE FROM dict_city WHERE full_name='市辖区' AND children_num =1
SELECT * FROM dict_city WHERE full_name='市辖区' AND children_num >0

DELETE FROM `dict_city` WHERE  `id`='1101';
UPDATE dict_city SET parent_id='11',grade=2 WHERE parent_id='1101';
UPDATE dict_city SET grade=3 WHERE id LIKE '1101%' AND grade=4;


DELETE FROM `dict_city` WHERE  `id`='1201';
UPDATE dict_city SET parent_id='12',grade=2 WHERE parent_id='1201';
UPDATE dict_city SET grade=3 WHERE id LIKE '1201%' AND grade=4;


DELETE FROM `dict_city` WHERE  `id`='3101';
UPDATE dict_city SET parent_id='31',grade=2 WHERE parent_id='3101';
UPDATE dict_city SET grade=3 WHERE id LIKE '3101%' AND grade=4;


DELETE FROM `dict_city` WHERE  `id`='5001';
UPDATE dict_city SET parent_id='50',grade=2 WHERE parent_id='5001';
UPDATE dict_city SET grade=3 WHERE id LIKE '5001%' AND grade=4;


DELETE FROM `dict_city` WHERE  `id`='620201';
UPDATE dict_city SET parent_id='6202',grade=3 WHERE parent_id='620201';

update dict_city SET children_num=0 WHERE parent_id like '1101%' AND grade=3;
update dict_city SET children_num=0 WHERE parent_id like '1201%' AND grade=3;
update dict_city SET children_num=0 WHERE parent_id like '3101%' AND grade=3;
update dict_city SET children_num=0 WHERE parent_id like '5001%' AND grade=3;
UPDATE dict_city SET children_num=0 WHERE parent_id='6202';