How to Import Data from a CSV in MySQL Workbench | AmitThinks

in this video we will learn how to easily import data in MySQL workbench so let's say we have the following database and we want to import a CSV file which is on the desktop here it is we want to import this data this is a CSV file so for that let's say I'll just right click on tables okay and table data import wizard I'll click on it but if you want to import the record in the current Table only you can right click and do this here okay I'll do this and show all other things import wizard you can easily import CSV Json data files we have a CSV file so I'll just click on browse go to desktop and just click on open okay I'll now click next here now do you want to import the data in the current Table employee no I want to create a new table so I'll create a new table let's say amp records I can also change the name let's say EMP deck okay and the database is the same Amit Ami DB I'll click on next let's say if there's an error or not no it worked so these are the columns and these are the records in the EMP records which is on a desktop so this will import here that's it nothing else and that too in a new table okay all the records which is on the desktop EMP records CSV file click next following task will now be performed prepare import just click next finish performing task click next table Amit DB dot EMP Rec was created click finish five records imported okay and it was on the desktop okay now let's see where is our table I'll click refresh and here is a record okay sorry these are the columns what I'll do I'll just directly create select star from command sorry select star from what is the name of our EMP Rec table select an imp here it is and you can match this with our desktop which we just imported desktop CSV file here it is you can match it it is same so this is how we can easily import data in MySQL workbench from a CSV file.json file we can import it in the current table or in a new table thank you for watching the video

Channel: Amit Thinks

Views: 9,997

Keywords: import csv file in mysql table by using mysql workbench, mysql workbench, how to import excel file to mysql workbench, import mysql table, mysql tutorial, import csv, mysql dba, mysql workbench import, import csv to mysql, csv file to mysql, csv to mysql, mysql tutorial for beginners

Id: El_QkLkO_9k

Length: 2min 36sec (156 seconds)

Published: Thu Sep 07 2023