List of Indian Cities

Table Columns


city_id city_name state_id state_name
183 Ghaziabad 34 Uttar Pradesh
244 Jodhpur 29 Rajasthan
412 Pune 24 Maharashtra

Use this generator to create an SQL dump of a list of Cities, Towns and Villages in India. To create a quick dump, click the generate button below. It'll create a table structure identical to one displayed in the preview on the left.

To customize your table structure, you can edit the column names, add or edit columns and reorder them by dragging the preview itself.

For detailed description of what each input does, hover over the information icon next to it.

Note: If you are using phpmyadmin to import the file, scroll down to "Format-Specific Options" and uncheck "Do not use AUTO_INCREMENT for zero values"

Copyright © 2011, 2016-2018 - BWD MEDIA LIMITED
Web Design & Digital Marketing Agency Hamilton
Call Now Enquire