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-