![]() The csv has about 47,000 customer entries. ) ENGINE=InnoDB AUTO_INCREMENT=33298 DEFAULT CHARSET=latin1 ![]() `user_id` int(11) NOT NULL AUTO_INCREMENT, `has_been_initially_contacted` varchar(16) CHARACTER SET utf8 DEFAULT NULL, `sp_categories` varchar(1024) CHARACTER SET utf8 DEFAULT NULL, `num_of_reviews` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `website` varchar(254) CHARACTER SET utf8 DEFAULT NULL, `email_address` varchar(254) CHARACTER SET utf8 DEFAULT NULL, `last_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `first_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `fax` varchar(45) CHARACTER SET utf8 DEFAULT NULL, `phone` varchar(45) CHARACTER SET utf8 DEFAULT NULL, `longitude` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `latitude` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `zipcode` varchar(255) CHARACTER SET utf8 DEFAULT NULL, ![]() `state` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `city` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `address2` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `address1` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `rating` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `in_business_since` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `services` varchar(1024) CHARACTER SET utf8 DEFAULT NULL, `description` varchar(8192) CHARACTER SET utf8 DEFAULT NULL, `hours` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, The table structure is: CREATE TABLE `sp_personal_info13` ( I'm importing with all the default options, encoding as latin1. I have a csv full of customer data, and am getting a number of errors when trying to import it into MySQL using Sequel Pro's Import function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |