Data Manipulation Language - DML

DML - Data Manipulation Language

Hey Guys Today I will tell you about the DML commands The DML is the Data Manipulation Language and in the DML Commands we learn that how to insert the values into the created table .

now without any delay lets start today's blog.

In today's blog 

we learn about the DML commands and how to insert values into the  table .
lets start today's blog

INSERTING VALUES INTO EXISTING TABLE

now to insert the values into the table , the insertion of the values in the table is known as the DML -Data Manipulation Language

to insert the values we need to enter the command as -

INSERT INTO < TABLE NAME > VALUES ( 1 , 2 , 3 ) ;

Always remember -

1 - while inserting the values you need to write the values in sequence with the column name which you enter in your table .
2 - enter the strings in the quotes ( " " ) in short way enter the characters in the quotes .

Suppose there is a table named student and the first column of the table is roll_no and the second column is name , third column is mobile_no fourth column is age sop you need to enter the values with the insert command and also in sequence with the column .

suppose we need to insert the value of the first student in the above example so we need to enter the commands as -

INSERT INTO STUDENT VALUES ( 1 , " NAME OF STUDENT " , ***582***** , 17 ) ;

in the above command we enter the values in the sequence so that we enter the 1 as the roll no and " name of student " in the name and ****** 582 **** in the phone no and 17 as the age of the student .

this is all about the DML in this blog thank you for visiting keep visiting .


For word file of this blog - Click Here


IN THE NEXT BLOG WE LEARN MORE ABOUT THE DML IN THE SQL AND OTHER COMMANDS AND THE OTHER WORKING  IN PYTHON AND OTHER IMPORTANT SUB TOPICS . THANK YOU FOR VISITING , KEEP LEARNING STAY TUNED FOR NEXT BLOG , FOLLOW OUR BLOG FOR REGULAR UPDATES , VIEW OUR PREVIOUS BLOG FOR THE BASIC CONCEPTS OF PYTHON AND OTHER BASIC CONCEPTS OF COMPUTER AND ALSO FOR THE IMPORTANT DEFINITIONS OF THE SQL , VISIT OUR SECOND BLOG – indianbasics.blogspot.com , VISIT OUR YOUTUBE CHANNEL -  Learn Python Our youtube channel will give you the short motivational speeches of the great person in the present there is only five motivational videos on channel but in future I will upload the motivational videos soon .VISIT OUR INSTAGRAM PAGE – instagram.com/learnpython16 , Our instagram page is also a new page i just created few days ago but stay tuned I will upload the post very soon . Please support us by following our blog and by subscribing our youtube channel and by following our instagram page .