Hi all, I hava a mysql database wich contain some country name only country names some a old like USSR ... I have to add some field into this db from the file found at the ripe net ftp.ripe.net file : iso3166-countrycodes.txt
see part of this file : Some Codes from ISO 3166 Updated by the RIPE Network Coordination Centre. Source: ISO 3166 Maintenance Agency Latest change: Thu Aug 7 17:59:51 MET DST 1997 Country A 2 A 3 Number ---------------------------------------------------------------------- AFGHANISTAN AF AFG 004 ALBANIA AL ALB 008 ALGERIA DZ DZA 012 AMERICAN SAMOA AS ASM 016 .... List of changes applied, as specified in registration newsletters: Newsletter III-1, 1989-12-5: Burma deleted, Myanmar added (same numeric value, change of country name) .... my bd countain field like : country_us, country_de .... how can I elegantly add the field from the ripe file that I didn't hav into my db ? thanks. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
