Add the connection information to MySQL Workbench. What’s more annoying is that some commas are escaped with 's, and some are placed within " ". To get connected, do the following: In the Azure portal, look for the connection information on the Overview pane of your Azure Database for MySQL. There are only 2 fields shown here but because Hat, has been used, MySQL is treating it as 3. Hat-glasses-and-moustache-print-racerback-tank-top,Hat, Glasses and Moustache Print Racerback Tank Top , Now the easiest way I could think of would be to use LOAD DATA INFILE as shown below… LOAD DATA INFILE '/home/shopify/shopify_all_products.csv'įIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'Īll works fine until line 2481 when this happens… In mysql's documentation it says that you can specify columns, but from my research it seems that you can only specify the columns of the csv file. So I have a CSV file (link below if you are interested) and I’m trying to import this into a MySQL database. Just when you think something is going to be simple, it turns out to be a right bum Importing the csv files into MySQL will help the organization in analyzing the data using these visualization tools. You can insert your rows from a CSV file by copying them over to INSERT statements, and then running them one by one, but that would take quite a lot of time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |