· 8 years ago · Feb 11, 2018, 11:44 AM
1--
2-- Table structure for table `state`
3--
4
5DROP TABLE IF EXISTS `state`;
6CREATE TABLE IF NOT EXISTS `state` (
7 `StateId` int(11) NOT NULL AUTO_INCREMENT,
8 `StateName` varchar(800) DEFAULT NULL,
9 PRIMARY KEY (`StateId`)
10) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;
11
12--
13-- Dumping data for table `state`
14--
15
16INSERT INTO `state` (`StateId`, `StateName`) VALUES
17(10, 'Andhra Pradesh'),
18(11, 'Arunachal Pradesh'),
19(12, 'Assam'),
20(13, 'Bihar'),
21(14, 'Chhattisgarh'),
22(18, 'Goa'),
23(20, 'Gujarat'),
24(21, 'Haryana'),
25(23, 'Himachal Pradesh'),
26(24, 'Jammu & Kashmir'),
27(25, 'Jharkhand'),
28(26, 'Karnataka'),
29(27, 'Kerala'),
30(29, 'Madhya Pradesh'),
31(30, 'Maharashtra'),
32(32, 'Manipur'),
33(33, 'Meghalaya'),
34(34, 'Mizoram'),
35(35, 'Nagaland'),
36(36, 'Orissa'),
37(38, 'Punjab'),
38(47, 'Telangana'),
39(40, 'Rajasthan'),
40(41, 'Sikkim'),
41(42, 'Tamil Nadu'),
42(43, 'Tripura'),
43(44, 'Uttar Pradesh'),
44(45, 'Uttarakhand'),
45(46, 'West Bengal');