Virajsinh

india_state_guj_dist

Feb 16th, 2020
48
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #India State List
  2. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'AN', 'Andaman and Nicobar Islands');
  3. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'AP', 'Andhra Pradesh');
  4. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'AR', 'Arunachal Pradesh');
  5. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'AS', 'Assam');
  6. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'BR', 'Bihar');
  7. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'CG', 'Chandigarh');
  8. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'CH', 'Chhattisgarh');
  9. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'DN', 'Dadra and Nagar Haveli');
  10. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'DD', 'Daman and Diu');
  11. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'DL', 'Delhi');
  12. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'GA', 'Goa');
  13. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'GJ', 'Gujarat');
  14. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'HR', 'Haryana');
  15. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'HP', 'Himachal Pradesh');
  16. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'JK', 'Jammu and Kashmir');
  17. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'JH', 'Jharkhand');
  18. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'KA', 'Karnataka');
  19. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'KL', 'Kerala');
  20. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'LA', 'Ladakh');
  21. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'LD', 'Lakshadweep');
  22. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'MP', 'Madhya Pradesh');
  23. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'MH', 'Maharashtra');
  24. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'MN', 'Manipur');
  25. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'ML', 'Meghalaya');
  26. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'MZ', 'Mizoram');
  27. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'NL', 'Nagaland');
  28. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'OR', 'Odisha');
  29. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'PY', 'Puducherry');
  30. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'PB', 'Punjab');
  31. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'RJ', 'Rajasthan');
  32. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'SK', 'Sikkim');
  33. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'TN', 'Tamil Nadu');
  34. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'TS', 'Telangana');
  35. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'TR', 'Tripura');
  36. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'UP', 'Uttar Pradesh');
  37. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'UK', 'Uttarakhand');
  38. INSERT INTO `tbl_state` (`state_id`, `state_code`, `state_name`) VALUES (NULL, 'WB', 'West Bengal');
  39.  
  40. #Gujarat Dist List
  41. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Ahmedabad', 'Active');
  42. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Amreli', 'Active');
  43. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Anand', 'Active');
  44. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Aravalli', 'Active');
  45. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Banaskantha', 'Active');
  46. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Bharuch', 'Active');
  47. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Bhavnagar', 'Active');
  48. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Botad', 'Active');
  49. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Chhota Udaipur', 'Active');
  50. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Dahod', 'Active');
  51. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Dang', 'Active');
  52. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Devbhoomi Dwarka', 'Active');
  53. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Gandhinagar', 'Active');
  54. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Gir Somnath', 'Active');
  55. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Jamnagar', 'Active');
  56. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Junagadh', 'Active');
  57. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Kutch', 'Active');
  58. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Kheda', 'Active');
  59. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Mahisagar', 'Active');
  60. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Mehsana', 'Active');
  61. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Morbi', 'Active');
  62. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Narmada', 'Active');
  63. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Navsari', 'Active');
  64. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Panchmahal', 'Active');
  65. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Patan', 'Active');
  66. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Porbandar', 'Active');
  67. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Rajkot', 'Active');
  68. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Sabarkantha', 'Active');
  69. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Surat', 'Active');
  70. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Surendranagar', 'Active');
  71. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Tapi', 'Active');
  72. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Vadodara', 'Active');
  73. INSERT INTO `tbl_dist` (`dist_id`, `state_id`, `dist_name`, `status`) VALUES (NULL, '12', 'Valsad', 'Active');
RAW Paste Data