Update Command

Update Command

In Previous Blog

Hey guys welcome to our new blog post in this blog we will learn about the udate command of sql which is used to change the data we input in our table .

IN TODAY'S BLOG

in this blog we learn about the select and update command of sql

SELECT COMMAND
select command is use to select the columns / frequency / particular column / particilar name and in this blog we will learn about 1 command of sql and we also learn about the update command of sql which is used to update the details of any thing .

To display the records of existing table
now , To display the records of existing table we need to use the select command as - SELECT * FROM ( < TABLE NAME > ) ;
in this command star ( * ) means all and this command is use to display the records which we enter in our table .
let's take an example - suppose there is a table named student and now you need to see the records you enter in the table , to show the records of the table you need to enter the command as -
SELECT * FROM STUDENTS ;

UPDATE COMMAND

this command is used to change the value of a particular record
suppose there is a table named student in that table you enter the age 15 instead of 17 of a student so to correct that age you need ot enter the command as -

UPDATE STUDENT SET AGE = 17 WHERE ROLL_NO IS 34 ;

in this command we use set age = because we need to change the age to change the age of a particular student we need to enter the roll_no of a student as the roll_no is taken as primary key so the age will change correctly that's all about todays blog . thank you for visiting .


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 – customercarereport.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 Six 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 .