How to insert data into table in MySQL

Insert data into table- 

insert into employee
( Emp_ID,FirstName,LastName,Department,Mobile_No,Salary,Address)

Insert Data into the tableImport the data from excel 

  • Data should be arrange in the table format and save the .csv format
  • Now select the import and choose the file
  • Now data are inserted into the table.

Import tha data from excel

After inserting the data table is-

Final table


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s