Re: SQL dumps for PHP forms of commonly used data
| From: | Miles Thompson | Date: | Sat, 02 Dec 2000 14:14:37 +0000 |
| Subject: | Re: SQL dumps for PHP forms of commonly used data | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28361@lists.php.net to get a copy of this message | ||
Here ya go ...
# Country table contains list of countries from ISO according to ISO 3166
Maintenance Agency. The list can be downloaded from
http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1/db_en.html
and consists
of two columns, the country and the two letter code. Order of fields matches
the arrangement of the list.
drop table if exists country_code ;
create table country_code (
cCountry varchar(20) ,
cCountryCode char(2) primary key ) ;
Miles
Kevin Ferron wrote:
> can anyone think of where a good resource for finding SQL dumps of commonly
> used information could be?
>
> ie. countries/country codes/zip codes/area codes
>
> thanks
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net