Indian State, District, City SQL Database

Indian State, District, City SQL Database

This is clean and neat database of Indian State, District, City SQL Database. Download link contains entire database of Indian State, District and city.

  • State : This has 35 records.
CREATE TABLE state (
   state_id int(11) NOT NULL,
   state_title varchar(50) NOT NULL,
   state_description text NOT NULL,
   status varchar(10) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  • District: This has 640 records.
CREATE TABLE district (
   districtid int(11) NOT NULL,
   state_id int(11) NOT NULL,
   district_title varchar(50) NOT NULL,
   district_description text NOT NULL,
   district_status varchar(10) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  • City: This has 5924 city records.
CREATE TABLE city (
   id int(11) NOT NULL,
   name varchar(100) NOT NULL,
   districtid int(11) DEFAULT NULL,
   state_id int(11) DEFAULT NULL,
   description text NOT NULL,
   status varchar(10) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

StudentProjects.Live

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments