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 ?