Use Indian Products


Products
 AVOID
Following are the brands we listed as good reliable Indian Brands. Please try to use these products on your daily use.

If any other brand you believe with good quality please forward to us. We will add that also to this list.

SQL Table for All Districts in India



— Table structure for table `all_districts`

CREATE TABLE IF NOT EXISTS `all_districts` (
`district_id` int(10) NOT NULL AUTO_INCREMENT,
`state_id` int(10) DEFAULT NULL,
`district_name` varchar(75) DEFAULT NULL,
UNIQUE KEY `district_id` (`district_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=599 ;


— Dumping data for table `all_districts`

INSERT INTO `all_districts` (`district_id`, `state_id`, `district_name`) VALUES
(1, 1, ‘Nellore’),
(2, 1, ‘Cuddapah’),
(3, 1, ‘Karim Nagar’),
(4, 1, ‘Kurnool’),
(5, 1, ‘West Godavari’),
(6, 1, ‘Srikakulam’),
(7, 1, ‘Anantpur’),
(8, 1, ‘Adilabad’),
(9, 1, ‘Chittor’),
(10, 1, ‘east Godavari’),
(11, 1, ‘Guntur’),
(12, 1, ‘Hyderabad Urban’),
(13, 1, ‘Khammam’),
(14, 1, ‘Krishna’),
(15, 1, ‘Mehboobnagar’),
(16, 1, ‘Medak’),
(17, 1, ‘Nalgonda’),
(18, 1, ‘Nizamabad’),
(19, 1, ‘Prakasam’),
(20, 1, ‘Ranga Reddy’),
(21, 1, ‘Vishakapatnam’),
(22, 1, ‘Vizianagaram’),
(23, 1, ‘Warangal’),
(24, 2, ‘Karimganj’),
(25, 2, ‘Darrang’),
(26, 2, ‘Dibrugarh’),
(27, 2, ‘Morigaon’),
(28, 2, ‘Tinsukia’),
(29, 2, ‘Bongaigaon’),
(30, 2, ‘Nalbari’),
(31, 2, ‘Kokrajhar’),
(32, 2, ‘Kamrup’),
(33, 2, ‘Karbi-Anglong’),
(34, 2, ‘Nagaon’),
(35, 2, ‘N.C.Hills’),
(36, 2, ‘Dhemaji’),
(37, 2, ‘Hailakandi’),
(38, 2, ‘Lakhimpur’),
(39, 2, ‘Sonitpur’),
(40, 2, ‘Dhubri’),
(41, 2, ‘Goalpara’),
(42, 2, ‘Barpeta’),
(43, 2, ‘Golaghat’),
(44, 2, ‘Jorhat’),
(45, 2, ‘Sibsagar’),
(46, 2, ‘Cachar’),
(47, 3, ‘Diban Valley( Anini Valley)’),
(48, 3, ‘East Kameng Seppa’),
(49, 3, ‘Itanagar’),
(50, 3, ‘East Siang(Passighat)’),
(51, 3, ‘Lohit(Tezu)’),
(52, 3, ‘Lower Subansiri(Ziro)’),
(53, 3, ‘Khonsa’),
(54, 3, ‘Roin’),
(55, 3, ‘Tawang’),
(56, 3, ‘Changalang’),
(57, 3, ‘Dibang Valley’),
(58, 3, ‘Daporijo’),
(59, 3, ‘Bomdila’),
(60, 3, ‘Alog( West Siang )’),
(61, 4, ‘Panchmahals’),
(62, 4, ‘Vadodara’),
(63, 4, ‘Amrela’),
(64, 4, ‘Kheda’),
(65, 4, ‘Ahmedabad’),
(66, 4, ‘Valsad’),
(67, 4, ‘Junagadh’),
(68, 4, ‘Mehsana’),
(69, 4, ‘Banaskantha’),
(70, 4, ‘Gandhinagar’),
(71, 4, ‘Bharuch’),
(72, 4, ‘Dangs’),
(73, 4, ‘Jamnagar’),
(74, 4, ‘Rajkot’),
(75, 4, ‘Surat’),
(76, 4, ‘Sabarkantha’),
(77, 4, ‘Kutch’),
(78, 4, ‘Bhavnagar’),
(79, 4, ‘Surendranagar’),
(80, 4, ‘Navsari’),
(81, 4, ‘Anand’),
(82, 4, ‘Narmada’),
(83, 4, ‘Patan’),
(84, 4, ‘Porbander’),
(85, 4, ‘Dahod’),
(86, 5, ‘Muzaffarpur’),
(87, 5, ‘Jehanabad’),
(88, 5, ‘Gaya’),
(89, 5, ‘Patna’),
(90, 5, ‘Saran( Chapra )’),
(91, 5, ‘Darbhanga’),
(92, 5, ‘Saharsa’),
(93, 5, ‘Purnea’),
(94, 5, ‘Bhagalpur’),
(95, 5, ‘Munger’),
(96, 5, ‘Aurangabad’),
(97, 5, ‘Bhojpur(Arah)’),
(98, 5, ‘Begusarai’),
(99, 5, ‘East Champaran’),
(100, 5, ‘Gopalganj’),
(101, 5, ‘Jamui’),
(102, 5, ‘Katihar’),
(103, 5, ‘Khagaria’),
(104, 5, ‘Madhepura’),
(105, 5, ‘Madhubani’),
(106, 5, ‘Nalanda’),
(107, 5, ‘Nawada’),
(108, 5, ‘Rohtas(Sasaram)’),
(109, 5, ‘Samastipur’),
(110, 5, ‘Sitamarhi’),
(111, 5, ‘Siwan’),
(112, 5, ‘Vaishali(Hajipur)’),
(113, 5, ‘West Champaran’),
(114, 5, ‘Kishanganj’),
(115, 5, ‘Araria’),
(116, 5, ‘Bhabua’),
(117, 5, ‘Banka’),
(118, 5, ‘Buxar’),
(119, 5, ‘Supaul’),
(120, 5, ‘Sekhpura’),
(121, 5, ‘Seohar’),
(122, 5, ‘Lakhisarai’),
(123, 6, ‘Gurgaon’),
(124, 6, ‘Rohtak’),
(125, 6, ‘Ambala’),
(126, 6, ‘Bhiwani’),
(127, 6, ‘Faridabad’),
(128, 6, ‘Hissar’),
(129, 6, ‘Jind’),
(130, 6, ‘Kaithal’),
(131, 6, ‘Karnal’),
(132, 6, ‘Kurukshetra’),
(133, 6, ‘Mahendragarh’),
(134, 6, ‘Panchkula’),
(135, 6, ‘Panipat’),
(136, 6, ‘Sonipat’),
(137, 6, ‘Yamunanagar’),
(138, 6, ‘Sirsa’),
(139, 6, ‘Rewari’),
(140, 6, ‘Jhanjhar’),
(141, 6, ‘Fatehabad’),
(142, 7, ‘Sirmour’),
(143, 7, ‘Hamirpur’),
(144, 7, ‘Kullu’),
(145, 7, ‘Solan’),
(146, 7, ‘Mandi’),
(147, 7, ‘Chamba’),
(148, 7, ‘Bilaspur’),
(149, 7, ‘Kangra’),
(150, 7, ‘Kinnaur’),
(151, 7, ‘Lahaul-Spiti’),
(152, 7, ‘Shimla’),
(153, 7, ‘Una’),
(154, 8, ‘Kathua’),
(155, 8, ‘Badgan’),
(156, 8, ‘Poonch’),
(157, 8, ‘Rajauri’),
(158, 8, ‘Baramula’),
(159, 8, ‘Doda’),
(160, 8, ‘Udhampur’),
(161, 8, ‘Jammu’),
(162, 8, ‘Kupwara’),
(163, 8, ‘Pulwama’),
(164, 8, ‘Anantnag’),
(165, 8, ‘Srinagar’),
(166, 8, ‘Leh’),
(167, 8, ‘Kargil’),
(168, 9, ‘Mysore’),
(169, 9, ‘Gulberga’),
(170, 9, ‘Chitradurga’),
(171, 9, ‘Kolar’),
(172, 9, ‘Bijapur’),
(173, 9, ‘Dakshina Kannada’),
(174, 9, ‘Raichur’),
(175, 9, ‘Bellary’),
(176, 9, ‘Belgaum’),
(177, 9, ‘Hassan’),
(178, 9, ‘Dharwad’),
(179, 9, ‘Bangalore Rural’),
(180, 9, ‘Shimoga’),
(181, 9, ‘Mandya’),
(182, 9, ‘Chickmagalur’),
(183, 9, ‘Bangalore Urban’),
(184, 9, ‘Madikeri’),
(185, 9, ‘Tumkur’),
(186, 9, ‘Bidar’),
(187, 9, ‘Karwar’),
(188, 9, ‘Udupi’),
(189, 9, ‘Davanagare’),
(190, 9, ‘Chamrajnagar’),
(191, 9, ‘Koppal’),
(192, 9, ‘Haveri’),
(193, 9, ‘Gadak’),
(194, 9, ‘Yadgir’),
(195, 10, ‘Kozhikode’),
(196, 10, ‘Kasaragod’),
(197, 10, ‘Idukki’),
(198, 10, ‘Ernakulam’),
(199, 10, ‘Cannanore’),
(200, 10, ‘Mallapuram’),
(201, 10, ‘Palghat’),
(202, 10, ‘Pathanamthitta’),
(203, 10, ‘Quilon’),
(204, 10, ‘Trichur’),
(205, 10, ‘Wayanad’),
(206, 10, ‘Trivandrum’),
(207, 10, ‘Kottayam’),
(208, 10, ‘Alapuzzha’),
(209, 11, ‘Sindi’),
(210, 11, ‘Vidisha’),
(211, 11, ‘Jabalpur’),
(212, 11, ‘Bhopal’),
(213, 11, ‘Hoshangabad’),
(214, 11, ‘Indore’),
(215, 11, ‘Rewa’),
(216, 11, ‘Satna’),
(217, 11, ‘Shahdol’),
(218, 11, ‘Chhindwara’),
(219, 11, ‘Ratlam’),
(220, 11, ‘Balaghat’),
(221, 11, ‘Betul’),
(222, 11, ‘Bhind’),
(223, 11, ‘Mandla’),
(224, 11, ‘Chhattarpur’),
(225, 11, ‘Damoh’),
(226, 11, ‘Datia’),
(227, 11, ‘Dewas’),
(228, 11, ‘Dhar’),
(229, 11, ‘Guna’),
(230, 11, ‘Gwalior’),
(231, 11, ‘Jhabua’),
(232, 11, ‘Sehore’),
(233, 11, ‘Mandsaur’),
(234, 11, ‘Narsinghpur’),
(235, 11, ‘Panna’),
(236, 11, ‘Raisen’),
(237, 11, ‘Rajgarh’),
(238, 11, ‘Sagar’),
(239, 11, ‘Seoni’),
(240, 11, ‘Morena’),
(241, 11, ‘Shivpuri’),
(242, 11, ‘Shajapur’),
(243, 11, ‘Tikamgarh’),
(244, 11, ‘Ujjain’),
(245, 11, ‘Khandwa’),
(246, 11, ‘Khargone’),
(247, 11, ‘Dindori’),
(248, 11, ‘Umaria’),
(249, 11, ‘Badwani’),
(250, 11, ‘Sheopur’),
(251, 11, ‘Katni’),
(252, 11, ‘Neemuch’),
(253, 11, ‘Harda’),
(254, 11, ‘Anooppur’),
(255, 11, ‘Burhanpur’),
(256, 11, ‘Ashoknagar’),
(257, 12, ‘Aurangabad’),
(258, 12, ‘Bandra(Mumbai Suburban district)’),
(259, 12, ‘Nagpur’),
(260, 12, ‘Pune’),
(261, 12, ‘Akola’),
(262, 12, ‘Chandrapur’),
(263, 12, ‘Jalgaon’),
(264, 12, ‘Parbhani’),
(265, 12, ‘Sholapur’),
(266, 12, ‘Thane’),
(267, 12, ‘Latur’),
(268, 12, ‘Mumbai-City’),
(269, 12, ‘Buldhana’),
(270, 12, ‘Dhule’),
(271, 12, ‘Kolhpur’),
(272, 12, ‘Nanded’),
(273, 12, ‘Raigad’),
(274, 12, ‘Amravati’),
(275, 12, ‘Nashik’),
(276, 12, ‘Wardha’),
(277, 12, ‘Ahmednagar’),
(278, 12, ‘Beed’),
(279, 12, ‘Bhandara’),
(280, 12, ‘Gadchiroli’),
(281, 12, ‘Jalna’),
(282, 12, ‘Osmanabad’),
(283, 12, ‘Ratnagiri’),
(284, 12, ‘Sangli’),
(285, 12, ‘Satara’),
(286, 12, ‘Sindudurg’),
(287, 12, ‘Yavatmal’),
(288, 12, ‘Nandurbar’),
(289, 12, ‘Washim’),
(290, 12, ‘Gondia’),
(291, 12, ‘Hingoli’),
(292, 13, ‘Imphal East’),
(293, 13, ‘Imphal West’),
(294, 13, ‘Thoubal’),
(295, 13, ‘Bishnupur’),
(296, 13, ‘Chandel’),
(297, 13, ‘Churachandpur’),
(298, 13, ‘Senapati’),
(299, 13, ‘Ukhrul’),
(300, 13, ‘Tamenglong’),
(301, 14, ‘Ri-Bhoi District’),
(302, 14, ‘South Garo Hills’),
(303, 14, ‘East Khasi Hill’),
(304, 14, ‘East Garo Hill’),
(305, 14, ‘West Garo Hill’),
(306, 14, ‘Jaintia Hill’),
(307, 14, ‘West Khasi Hill’),
(308, 15, ‘Luglei District’),
(309, 15, ‘Chimtipui District’),
(310, 15, ‘Aizawal’),
(311, 15, ‘Champhai’),
(312, 15, ‘Mamit’),
(313, 15, ‘Kolasib’),
(314, 15, ‘Serchhip’),
(315, 15, ‘Lawngtlai’),
(316, 16, ‘Wokha’),
(317, 16, ‘Phek’),
(318, 16, ‘Tuensang’),
(319, 16, ‘Mon’),
(320, 16, ‘Kohima’),
(321, 16, ‘Zunheboto’),
(322, 16, ‘Mokokchung’),
(323, 16, ‘Dimapur’),
(324, 17, ‘Khurda’),
(325, 17, ‘Navaragpur’),
(326, 17, ‘Navapada’),
(327, 17, ‘Gajapati’),
(328, 17, ‘Boudh’),
(329, 17, ‘Bhadrak’),
(330, 17, ‘Ganjam’),
(331, 17, ‘Dhenkanal’),
(332, 17, ‘Angul’),
(333, 17, ‘Puri’),
(334, 17, ‘Cuttak’),
(335, 17, ‘Sambalpur’),
(336, 17, ‘Kalhandi’),
(337, 17, ‘Koraput’),
(338, 17, ‘Phulbani’),
(339, 17, ‘Balangir’),
(340, 17, ‘Bargah’),
(341, 17, ‘Deogarh’),
(342, 17, ‘Jagatsinghpur’),
(343, 17, ‘Jajpur’),
(344, 17, ‘Jharsuguda’),
(345, 17, ‘Kendrapara’),
(346, 17, ‘Malkangiri’),
(347, 17, ‘Nayagarh’),
(348, 17, ‘Rayagada’),
(349, 17, ‘Sonepur’),
(350, 17, ‘Balasore’),
(351, 17, ‘Mayurbhanj’),
(352, 17, ‘Keonjhar’),
(353, 17, ‘Sundergarh’),
(354, 18, ‘Sangrur’),
(355, 18, ‘Jalandhar’),
(356, 18, ‘Ludhiana’),
(357, 18, ‘Bhatinda’),
(358, 18, ‘Kapurthala’),
(359, 18, ‘Patiala’),
(360, 18, ‘Amritsar’),
(361, 18, ‘Ferozepur’),
(362, 18, ‘Fatehgarh Saheb’),
(363, 18, ‘Ropar’),
(364, 18, ‘Gurdaspur’),
(365, 18, ‘Hosiarpur’),
(366, 18, ‘Faridkot’),
(367, 18, ‘Mansa’),
(368, 18, ‘Moga’),
(369, 18, ‘Muktsar’),
(370, 18, ‘Navansahar’),
(371, 19, ‘Jaipur’),
(372, 19, ‘Barmer’),
(373, 19, ‘Dungarpur’),
(374, 19, ‘Jodhpur’),
(375, 19, ‘Kota’),
(376, 19, ‘Udaipur’),
(377, 19, ‘Bikaner’),
(378, 19, ‘Dausa’),
(379, 19, ‘Bundi’),
(380, 19, ‘Sikar’),
(381, 19, ‘Tonk’),
(382, 19, ‘Jaisalmer’),
(383, 19, ‘Nagaur’),
(384, 19, ‘Rajsamand’),
(385, 19, ‘Banswara’),
(386, 19, ‘Bhilwara’),
(387, 19, ‘Ajmer’),
(388, 19, ‘Alwar’),
(389, 19, ‘Bharatpur’),
(390, 19, ‘Chittorgarh’),
(391, 19, ‘Churu’),
(392, 19, ‘Dholpur’),
(393, 19, ‘Ganganagar’),
(394, 19, ‘Jalor’),
(395, 19, ‘Jhalawar’),
(396, 19, ‘Jhunjhunu’),
(397, 19, ‘Pali’),
(398, 19, ‘Sawai Madhopur’),
(399, 19, ‘Sirohi’),
(400, 19, ‘Baran’),
(401, 19, ‘Hanumangarh’),
(402, 19, ‘Karauli’),
(403, 20, ‘East’),
(404, 20, ‘South’),
(405, 20, ‘West’),
(406, 20, ‘North’),
(407, 21, ‘Chennai’),
(408, 21, ‘Coimbotore’),
(409, 21, ‘Cuddalorei’),
(410, 21, ‘Dharmapuri’),
(411, 21, ‘Dindigul’),
(412, 21, ‘Erode’),
(413, 21, ‘Kancheepuram’),
(414, 21, ‘Kanniyakumari (HQ : Nagercoil)’),
(415, 21, ‘Karur’),
(416, 21, ‘Madurai’),
(417, 21, ‘Nagapattinam’),
(418, 21, ‘Namakkal’),
(419, 21, ‘Nilgiris (HQ: Udhagamandalam)’),
(420, 21, ‘Perambalur’),
(421, 21, ‘Pudukkottai’),
(422, 21, ‘Ramanathapuram’),
(423, 21, ‘Salem’),
(424, 21, ‘Sivaganga’),
(425, 21, ‘Thanjavur’),
(426, 21, ‘Theni’),
(427, 21, ‘Thoothkudi’),
(428, 21, ‘Tiruchiorappalli’),
(429, 21, ‘Tirunelveli’),
(430, 21, ‘Tiruvallur’),
(431, 21, ‘Tiruvannamalai’),
(432, 21, ‘Tiruvarur’),
(433, 21, ‘Vellore’),
(434, 21, ‘Villupuram’),
(435, 21, ‘Virudhunagar’),
(436, 22, ‘North District’),
(437, 22, ‘South District’),
(438, 22, ‘West District’),
(439, 22, ‘Dhalai District’),
(440, 23, ‘Allahabad’),
(441, 23, ‘Aligarh’),
(442, 23, ‘Bareilly’),
(443, 23, ‘Gonda’),
(444, 23, ‘Hardoi’),
(445, 23, ‘Kanpur Dehat’),
(446, 23, ‘Ghaziabad’),
(447, 23, ‘Unnav’),
(448, 23, ‘Varanasi’),
(449, 23, ‘Faizabad’),
(450, 23, ‘Gorakpur’),
(451, 23, ‘Jhansi’),
(452, 23, ‘Lucknow’),
(453, 23, ‘Agra’),
(454, 23, ‘Meerut’),
(455, 23, ‘Moradabad’),
(456, 23, ‘Barabanki’),
(457, 23, ‘Mainpuri’),
(458, 23, ‘Etawah’),
(459, 23, ‘Gazipur’),
(460, 23, ‘Etah’),
(461, 23, ‘Muzaffar Nagar’),
(462, 23, ‘Saharanpur’),
(463, 23, ‘Bulandshehar’),
(464, 23, ‘Mathura’),
(465, 23, ‘Firozabad’),
(466, 23, ‘Budaun’),
(467, 23, ‘Shahjahanpur’),
(468, 23, ‘Pilibhit’),
(469, 23, ‘Bijnor’),
(470, 23, ‘Rampur’),
(471, 23, ‘Kanpur(Nagar)’),
(472, 23, ‘Farrukhabad’),
(473, 23, ‘Fatehpur’),
(474, 23, ‘Pratapgarh’),
(475, 23, ‘Jalaun’),
(476, 23, ‘Hamirpur’),
(477, 23, ‘Lalitpur’),
(478, 23, ‘Mirzapur’),
(479, 23, ‘Basti’),
(480, 23, ‘Deoria’),
(481, 23, ‘Raebareili’),
(482, 23, ‘Sitapur’),
(483, 23, ‘Banda’),
(484, 23, ‘Lakhimpur-Khedi’),
(485, 23, ‘Bahraich’),
(486, 23, ‘Sultanpur’),
(487, 23, ‘Mau’),
(488, 23, ‘Azamgarh’),
(489, 23, ‘Jaunpur’),
(490, 23, ‘Balia’),
(491, 23, ‘Bhadoi’),
(492, 23, ‘Padrauna’),
(493, 23, ‘Maharajganj’),
(494, 23, ‘Siddharth Nagar’),
(495, 23, ‘Sunbhadra’),
(496, 23, ‘Mahoba’),
(497, 23, ‘Ambedkarnagar’),
(498, 23, ‘Gautam Bodda Nagar’),
(499, 23, ‘Maha Maya Nagar’),
(500, 23, ‘jyotiba Phoole Nagar’),
(501, 23, ‘Kaushambi’),
(502, 23, ‘Shooji Maharaj’),
(503, 23, ‘Chandauli’),
(504, 23, ‘Balrampur’),
(505, 23, ‘Shravati’),
(506, 23, ‘Bagpat’),
(507, 23, ‘Kanooj’),
(508, 23, ‘Oraiyya’),
(509, 23, ‘Sant Kabir Nagar’),
(510, 24, ‘Howrah’),
(511, 24, ‘Darjeeling’),
(512, 24, ‘Medinipur’),
(513, 24, ‘Murshidabad’),
(514, 24, ‘Coochbehar’),
(515, 24, ‘Malda’),
(516, 24, ‘Birbhum’),
(517, 24, ‘North Parganas’),
(518, 24, ‘South Parganas’),
(519, 24, ‘Bankura’),
(520, 24, ‘Bardhaman’),
(521, 24, ‘Jalpaiguri’),
(522, 24, ‘Hooghly’),
(523, 24, ‘Nadia’),
(524, 24, ‘Dakshin Dinajpur’),
(525, 24, ‘Purulia’),
(526, 24, ‘Uttar Dinajpur’),
(527, 24, ‘Siliguri’),
(528, 25, ‘New Delhi’),
(529, 25, ‘Central’),
(530, 25, ‘North’),
(531, 25, ‘North West’),
(532, 25, ‘West’),
(533, 25, ‘South West’),
(534, 25, ‘North’),
(535, 25, ‘North East’),
(536, 26, ‘North Goa’),
(537, 26, ‘South Goa’),
(538, 27, ‘Karikal’),
(539, 27, ‘Mahe’),
(540, 27, ‘Yaman’),
(541, 27, ‘Pondicherry’),
(542, 29, ‘Dama’),
(543, 29, ‘Diu’),
(544, 30, ‘Dadra’),
(545, 31, ‘Chandigarh’),
(546, 32, ‘Andaman’),
(547, 33, ‘Nicobar’),
(548, 33, ‘Nainital’),
(549, 33, ‘Almora’),
(550, 33, ‘Pitoragarh’),
(551, 33, ‘Udhamsingh Nagar’),
(552, 33, ‘Bageshwar’),
(553, 33, ‘Champawat’),
(554, 33, ‘Garhwal(Pauri)’),
(555, 33, ‘Tehri-Garhwal’),
(556, 33, ‘Chamoli( Gopeshwar )’),
(557, 33, ‘Uttarkashi’),
(558, 33, ‘Dehradun’),
(559, 33, ‘Rudraprayag’),
(560, 33, ‘Haridwar’),
(561, 34, ‘Deoghar’),
(562, 34, ‘Dhanbad’),
(563, 34, ‘Giridih’),
(564, 34, ‘Godda’),
(565, 34, ‘Gumla’),
(566, 34, ‘Hazaribagh’),
(567, 34, ‘Lohardaga’),
(568, 34, ‘Palamu’),
(569, 34, ‘Ranchi’),
(570, 34, ‘Dumka’),
(571, 34, ‘Chaibasa(West Singhbhum)’),
(572, 34, ‘Jamshedpur(East Singhbhum)’),
(573, 34, ‘Bokaro’),
(574, 34, ‘Chatra’),
(575, 34, ‘Garhwa’),
(576, 34, ‘Koderma’),
(577, 34, ‘Pakur’),
(578, 34, ‘Sahebganj’),
(579, 34, ‘Simdega’),
(580, 34, ‘Latehar’),
(581, 34, ‘Saraikela’),
(582, 34, ‘Jamtara’),
(583, 35, ‘Bastar’),
(584, 35, ‘Bilaspur’),
(585, 35, ‘Dantewada’),
(586, 35, ‘Dhamtari’),
(587, 35, ‘Durg’),
(588, 35, ‘Janjgir-Champa’),
(589, 35, ‘Jashpur’),
(590, 35, ‘Kanker’),
(591, 35, ‘Kawardha’),
(592, 35, ‘Korba’),
(593, 35, ‘Koriya’),
(594, 35, ‘Mahasamund’),
(595, 35, ‘Raigarh’),
(596, 35, ‘Rajnandgaon’),
(597, 35, ‘Surguja’),
(598, 35, ‘Raipur’);

SQL Table for All States in India



— Table structure for table `all_states`

CREATE TABLE IF NOT EXISTS `all_states` (
`state_id` int(10) NOT NULL AUTO_INCREMENT,
`state_name` varchar(75) DEFAULT NULL,
UNIQUE KEY `state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;


— Dumping data for table `all_states`

INSERT INTO `all_states` (`state_id`, `state_name`) VALUES
(1, ‘Andaman and Nicobar Islands’),
(2, ‘Andhra Pradesh’),
(3, ‘Arunachal Pradesh’),
(4, ‘Assam’),
(5, ‘Bihar’),
(6, ‘Chandigarh’),
(7, ‘Chhattisgarh’),
(8, ‘Dadra and Nagar Haveli’),
(9, ‘Daman and Diu’),
(10, ‘Delhi’),
(11, ‘Goa’),
(12, ‘Gujarat’),
(13, ‘Haryana’),
(14, ‘Himachal Pradesh’),
(15, ‘Jammu and Kashmir’),
(16, ‘Jharkhand’),
(17, ‘Karnataka’),
(18, ‘Kerala’),
(19, ‘Lakshadweep’),
(20, ‘Madhya Pradesh’),
(21, ‘Maharashtra’),
(22, ‘Manipur’),
(23, ‘Meghalaya’),
(24, ‘Mizoram’),
(25, ‘Nagaland’),
(26, ‘Orissa’),
(27, ‘Pondicherry’),
(28, ‘Punjab’),
(29, ‘Rajasthan’),
(30, ‘Sikkim’),
(31, ‘Tamil Nadu’),
(32, ‘Tripura’),
(33, ‘Uttaranchal’),
(34, ‘Uttar Pradesh’),
(35, ‘West Bengal’);