Home / Geographic / India Regions

India Regions

Rows 34

Last updated 2026-01-05 13:26:11

Download

Preview

id	name
1	Andaman and Nicobar Islands
2	Andhra Pradesh
3	Arunachal Pradesh
4	Assam
5	Bihar
6	Chhattisgarh
7	Dadra and Nagar Haveli
8	Daman and Diu
9	Delhi
10	Goa
11	Gujarat
12	Haryana
13	Himachal Pradesh
14	Jammu and Kashmir
15	Jharkhand
16	Karnataka
17	Kerala
18	Lakshadweep
19	Madhya Pradesh
20	Maharashtra
21	Manipur
22	Meghalaya
23	Mizoram
24	Nagaland
25	Orissa

Raw SQL

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `india_regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `india_regions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `india_regions` WRITE;
/*!40000 ALTER TABLE `india_regions` DISABLE KEYS */;
INSERT INTO `india_regions` VALUES (1,'Andaman and Nicobar Islands'),(2,'Andhra Pradesh'),(3,'Arunachal Pradesh'),(4,'Assam'),(5,'Bihar'),(6,'Chhattisgarh'),(7,'Dadra and Nagar Haveli'),(8,'Daman and Diu'),(9,'Delhi'),(10,'Goa'),(11,'Gujarat'),(12,'Haryana'),(13,'Himachal Pradesh'),(14,'Jammu and Kashmir'),(15,'Jharkhand'),(16,'Karnataka'),(17,'Kerala'),(18,'Lakshadweep'),(19,'Madhya Pradesh'),(20,'Maharashtra'),(21,'Manipur'),(22,'Meghalaya'),(23,'Mizoram'),(24,'Nagaland'),(25,'Orissa'),(26,'Pondicherry'),(27,'Punjab'),(28,'Rajasthan'),(29,'Sikkim'),(30,'Tamil Nadu'),(31,'Tripura'),(32,'Uttar Pradesh'),(33,'Uttaranchal'),(34,'West Bengal');
/*!40000 ALTER TABLE `india_regions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Categories

Popular

India Regions

Download

Preview

Raw SQL