For a recent project I had to find all the Sri Lankan District and related Cities to populate in two drop downs. The list is not fully complete and Kilinochchi District is not in the list.
Districts - 24
Cities - 2044
Two tables, city table refer district table by did.
Download Sri Lankan District - City Sql file
You can easily import this sql file to mysql using phpmyadmin.
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Thursday, September 2, 2010
Subscribe to:
Posts (Atom)