How to insert data into table in MySQL

Insert data into table- 

Query-
insert into employee
( Emp_ID,FirstName,LastName,Department,Mobile_No,Salary,Address)
values(5776,’Zahid’,’Iqbal’,’Computer’,12345,11000,’Chandigarh’)

Import 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.

After inserting the data table is-

Advertisements