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’)

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s