INSERT INTO `dictionary` (name, value, pid) select '华东-宿迁', 'cn-east-1', a.id from dictionary a where a.value = 'JDCLOUD_REGION'; INSERT INTO `dictionary` (name, value, pid) select '华东-上海', 'cn-east-2', a.id from dictionary a where a.value = 'JDCLOUD_REGION'; INSERT INTO `dictionary` (name, value, pid) select '华南-广州', 'cn-south-1', a.id from dictionary a where a.value = 'JDCLOUD_REGION';