I have been struggling long time to get the information for the country state Database Table Data and its implementation in My most of the application,
I have searched through net and now i got few data from the site and I have created Java file to generate the SQL Queries.
The Table Structure i have created as Follows.
Country
ID [PK]
NAME [VARCHAR].
State
ID [PK]
NAME [VARCHAR]
COUNTY_ID [PK] Foreign key to Country Table
You can download the java Class file to generate the SQL Queries directly from My Google Docs http://docs.google.com/Doc?docid=0AW0ekoc5wU3rZGYyMnZrZmtfN2NtYnF3dmQ0&hl=en
If you require the SQL File Directly you can download from My Docs as .
I am Thankful to the website http://www.microcosmotalk.com/tech/scripts/ for the datas of countries and States in their site javascipt file.
[I converted Java and sql file to txt format just to upload in Google Docs. :) ]
Hope it will help you out.
Any Concerns Contact :- askeralim@gmail.com
