Importing zip codes

I would like to import zip codes into the database.

 

The .sql file has the following structure :

INSERT INTO sys_zip_codes VALUES('5680', 'Vodelée', 'WNA', 4.7319820000, 50.1700230000, 1, 1, 'be');

 

When I run the import command in the database I get following error :

MySQL returned: 

#1136 - Column count doesn't match value count at row 1

 

How do I arrange the colums in the sys_zip_codes table to match the query ?

Quote · 11 Feb 2010

Hello, compare your sys_zip_codes table's structure with the sql dump, and remove all not required fields

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 12 Feb 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.