MySQL - INSERT values in the table

Our MySQL 4th Lecture:

In our previous tutorial we've created a table named Student where there were 4 attribute or column and now we will insert a row in our table by mySQL query -

Insert code for all tables:

   INSERT INTO table_name
   VALUES (value1,value2,value3,value4,...);

And for our Student table our Code will be :

   INSERT INTO student (ID, Name, Email, Address) 
   VALUES ('1402036', 'Maniruzzaman Akash', 'manirujjamanakash@gmail.com', 'Ishwarganj, Mymensingh, Bangladesh');

Then a row will be inserted in the table Student. Like this - Click Browse tab and you can get the value which has inserted in the table



We can also insert value from XAMPP control panel using Graphical User Interface and it is just click the insert tab and insert like me...


Thanks for staying with our MySQL tutorial and in our next tutorial we'll learn about SELECT statement in SQL..