Jan 17

MySql Tutorial11:How to insert data in to table using mysql?

To insert the data in to table we use insert statement :
To insert a complete row we use the following statement:

INSERT INTO <table_name>

(column_name1, column__name2, column_name3)

VALUES(value1,values2,’value3′);

 

In the above statement we give table name and columnnames with values .

In the following screenshot records are inserted in to student table.

insertdata1