PHP Code:
Error
SQL query:
--
-- Dumping data for table `address_format`
--
INSERT INTO `address_format` ( `address_format_id` , `address_format` , `address_summary` )
VALUES ( 1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country' ) , ( 2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country' ) , ( 3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country' ) , ( 4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country' ) , ( 5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country' ) , ( 6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country', '$postcode / $country' ) ;
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'
Then I tried importing in phpMYADMIN the same file again and I got this error afterwards. What I'm I doing wrong?
PHP Code:
Error
SQL query:
-- -- Dumping data for table `address_book` -- INSERT INTO `address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES (1, 1, 'm', NULL, '***', '***'', '***'', '', '***'', '***'', '', 223, 12), (2, 2, 'f', NULL, '***'', '***'', '***'', '', '***'', '***'', '', 223, 12), (3, 3, 'm', NULL, '***'', '***'', '***'', '', '***', '***', '', 13, 183), (4, 4, 'f', NULL, '***', '***', '***', '', '***', '***', '', 223, 62), (5, 5, 'm', NULL, '***', '***', '***', '', '***', '***', '', 223, 18), (6, 6, 'f', NULL, '***', '***', '***', '', '***', '***', '', 223, 4), (7, 4, 'f', NULL, '***', '***', '***', '', '***', '***,'[...]
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'
Bookmarks