Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

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. This SQL database has list of states, State-wise district records and District-wise city lists. It has more than 30+ state records and 600+ district records. This you can integrate with any of your project.

  • 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;

Database Information

  • The System has 3 database tables – state, district, city.
  • All 35 state records, 600 districts and 5900 city records stored in this system.
  • This is the backup of MySQL database.
  • MySQL Version – 5.2+

Comments ( 18 )

  1. thanks for data its really help me

  2. Sonpal Singh Sengar
    November 15, 2021 at 7:18 PM

    I am unable to download the things you provide here, facing issue
    “An application is preventing Microsoft Edge from safely connecting to this site”
    please make it sure the content is available for downloading.

  3. Hello, How are you.. Can you do c#.net code for this. I need 3 dropdowns. First it should display all state records in dropdown box, after selecting state then districts under state should load under district dropdown box, After selecting district it should load city records in city dropdown box.

  4. Thank you I was looking for this kind of database

  5. Thanks. It is working well

  6. Thank you. I was thinking of how to write all state, district and city records. But this ready database I got. It will help me a lot for my project.

  7. is it free?

  8. how to connect this database in php

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in Android, 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.

Follow Me