Problems Uploading Data Into in Mysql 8.0

GETTING STARTED

How to Import a CSV file into MySQL Workbench

With No Errors

Photo by Noah Boyer on Unsplash

If you are familiar with the job-hunting process, y'all probably already noticed that some companies like using take-home assignments to decide if a candidate is the right fit or not. Since most companies use SQL, it'due south common that they want to encounter if you tin can solve problems using SQL. However, not all the companies will provide you any dataset to work with. It's likely that a company might just provide a table schema, and you lot might be wondering if your queries can actually run. Therefore, importing a dataset into a database can be very helpful.

In this commodity, I will comprehend how to install MySQL Workbench and import data into MySQL Workbench step past footstep.

Getting Started

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. Information technology is available on Windows, Linux, and Mac Bone X. In this article, I volition be using the Mac OSX organisation. To get started, yous will need to install MySQL and MySQL Workbench.

To install MySQL using the package installer:

Download the disk prototype (.dmg) file (the community version is available here) that contains the MySQL package installer. Double-click the file to mountain the disk epitome and meet its contents.

MySQL Installation Page (Screenshot past Author)

Don't forget this password since you lot will need this to log into your MySQL workbench later! (Screenshot by Author)

After installing both MySQL and MySQL Workbench, you tin can at present open MySQL Workbench. I fabricated a mistake by not installing MySQL since I forgot the SQL I installed was Postgresql. If yous didn't install MySQL, you wouldn't be able to connect to a database.

MySQL Workbench cannot find any MySQL → TIME TO DOWNLOAD MYSQL. (Screenshot past Author)

If y'all download MySQL successfully, you lot volition run into a pop-upwards window to enter the same countersign you gear up previously. After entering the password, you should see something like this:

Yay! Yous are connected to MySQL (Screenshot by Author)

Now you tin click into the MySQL instance.

If you still see this error even after installing MySQL, y'all can click the "Stopped" button at the elevation-right corner of the screen or click the "Startup/Shutdown" button.

No connection established error message (Screenshot by Author)

(Screenshot by Author)

Creating a Schema/Table

If you desire to keep tables more organized, y'all tin create a schema for each projection you are working on. This way, it will exist easier for you lot to find unlike tables for each project. You tin but correct-click and select Create Schema."

How to create a schema (Screenshot by Author)

At present that yous've created a schema, you lot tin either select "Create Table" or "Tabular array Data Import Sorcerer" to build a table within the schema.

How to create a tabular array (Screenshot by Writer)

Here's what you lot will meet you create a table:

Creating an empty table (Screenshot by Author)

Import a CSV file

First, find the file path of the CSV file that you want to import.

Notice the path to the data (Screenshot past Writer)

Y'all tin either create a new table or add together to an existing table (Screenshot by Author)

Unfortunately, I was not able to import the data because "Table Information Import Wizard fails on UTF-8 encoded file with BOM." I didn't understand why this happened since I did save the file as UTF-8 CSV.

In the cease, I constitute out that somehow for the Mac OSX system, we need to open the CSV or excel file using Numbers/Notepad, and and so export the file as .csv format.

Saving the file equally a CSV file (Screenshot past Author)

Sometimes it will only work if yous change encoding to others (Screenshot by Author)

Congratulations!!! You did information technology! Now you accept successfully loaded the CSV file to MySQL workbench, and y'all tin can start writing queries!

The outcome from a simple query (Screenshot by Author)

If you find this helpful, please follow me and check out my other blogs. ❤️

Until adjacent time, happy learning! 👩🏻‍💻

wilsondoomplast.blogspot.com

Source: https://towardsdatascience.com/how-to-import-a-csv-file-into-mysql-workbench-17cb120169c8

Share this post