![]() ![]() The theory is that from one program to a CSV document, you may transfer complex information and afterward import the information in that CSV document to some other program.įor instance, Database and contact administrators also endorse CSV files. In this tutorial, we will learn how to import data from a CSV file into MySQL workbench. To create a CSV file, you have to open Microsoft Excel in your system and add some data as we have created a file and added the below record into it. Make sure to create field names easy to make it convenient for yourself. Now, save this file with the ‘.csv’ extension. You can change its file format while saving it to any folder. ![]() Go to ‘File,’ and hit on ‘Save As.’ Select the location, name the document and below the name field, select the file format. To import your CSV file data into MySQL, you must first connect your Workbench with the Database. For this purpose, open the newly install MySQL Workbench 8.0 and go to the ‘Database’ option. Hit on the ‘Connect to Database’ option from the listed options. Select your Database, e.g., ‘Stored Connection.’ After that, set the ‘Parameters’ and then hit the ‘OK’ button to link to the Database. You will be heading to the MySQL Workbench Schema’s Graphical User Interface window. In the Local instance or database window, you will see a list of schemas already created by MySQL. ![]() You have to generate a new database or use the already created Database as we have a database ‘data’ as our default database. In the query area of schema’ data,’ create a table ‘book’ using the schema by ‘use’ command. Make sure to use the same names for the file and its fields as used in the CSV file. After that, select the create query to be executed and tap on the flash button. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |