Member-only story
Import CSV file with MySQL Workbench
CSV imports with MySQL Workbench is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBAs and Developers. Continue reading to learn how easy it is using MySQL Workbench…
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
Starting out, in the navigation pane, right-click the table you want to import CSV data into and then click Table Data Import Wizard:
You are then presented with a Select File to Import option/screen. You can type in the File Path or navigate to the import file using the Browse button:
Once the file to import is chosen, a Select Destination screen is displayed with a few options. Here you specify the table you want. By default…
