INSERT INTO states (`name`, `country_id`, `x`) VALUES ('Gilgit Baltistan', 154, 154);
INSERT INTO states (`name`, `country_id`, `x`) VALUES ('Kashmir', 154, 154);

INSERT INTO cities ( name, state_id)
VALUES
  ( 'New Mirpur City', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Muzaffarabad', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Rawalakot', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kotli', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Bhimber', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Hattian Bala', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Pallandri', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Athmuqam', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Farwad Kahuta', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Mangla Hamlet', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Dadyal', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Chakswari', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Hajira', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Chikkar', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Abbaspur', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Samahni', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Sehnsa', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Khai Gala', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Khuiratta', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'DhirKot', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Garhi Dupatta', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kel', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Sharda', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Keran', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Leepa', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Taobat', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Dao Khan', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Dowarian', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Balathi', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Ratta', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Ghora', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Thalarajwali Khan', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Nagyal', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Abdullahpur', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Pakhral', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kathar Dilawar Khan', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Jangian Kotla', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kot Tarhala', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kalri', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Upper Neelam', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Devi Gali', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kakra Town', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Islamgarh', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Mandi Mirpur', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Minimarg', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Sudhan Galli', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Kutton', (SELECT id FROM states WHERE name = 'Kashmir')),
  ( 'Skardu', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Diamir', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Chilās', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Khaplu', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Tolti', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Shigar', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Nagar Khas', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Jaglot', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Karimabad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Danyor', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Astore', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Kharfaq', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Haldi', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Thalichi', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Shimshal', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Sost', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Bunji', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Askole', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Gulmit', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Misgar', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Phander', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Passu', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Naltar Valley', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Nasirabad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Mayoon', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Jalal Abad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Oshikhandass', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Shigar District', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Yugo', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Atta Abad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Palpaldo', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Marol', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Ganish', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Ghulkin', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Sikandarabad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Hisper', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Chhamugarh', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Jafar Abad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Konodas', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Sherqilla', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Altit', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Hassanabad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Hunza', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Khanabad', (SELECT id FROM states WHERE name = 'Gilgit Baltistan')),
  ( 'Rattu', (SELECT id FROM states WHERE name = 'Gilgit Baltistan'));
  
  UPDATE cities SET state_id = (SELECT id FROM states WHERE name = 'Gilgit Baltistan') WHERE  name= 'Chitral';