How to upload a csv file into MySQL workbench database

There are various methods to upload your csv file to MySQL workbench but this one is one out of many;

1. Create a new schema in the connected server and give it a name of your choice then click on apply button on the bottom right corner.

• 2. Review the SQL Script to be Applied on the Database

3. Click on Finish to apply SQL script to the database.

4. The schema automatically reflects here as shown below. The name of my schema here is "My" with the color orange.

5. Let's get to business;

• right click on the 'my' schema and it brings out this list of option then you click on Table Data Import Wizard to import the csv datasets.

6. Select the file you want to upload by clicking on browse

7. There are two options here; the first one is to use existing table or Create new table and an option to drop table if it exists.

I selected a dataset which is 'sales' from my desktop and I clicked on create new table you can also rename the sales data to another thing depending on you, I left mine as Sales

8. Here you'd have to configure the import settings and also confirm the field type with you data whether it is integer for 'int', text, and many more format based on the dataset you are importing after that you click on the next button.

9. second to the last step is to click Next so the import process can begin.

10. Sit back and relax while the data gets imported, you can check the progress via the logs option on the bottom left corner.

Once the data is done importing, you click on finish and go back to the schema and refresh.

your data is ready for use.

If you have any alternative to the above steps mentioned in this article, let me know in the comment section.