Update Table in MYSQL|| MySQL Tutorial
Today in this particular video of mysql series I will be discussing about MySQL UPDATE Statement
You can check the previous topic of mysql on the playlist given in the I button above
So without any further delay let's get started
The UPDATE statement is used to modify the existing records in a table.
UPDATE Syntax
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Today we are using table student_table under school_details
Let's update Lilly fort as class teacher of class 4
So the syntax will be
Update student_table
SET class_teacher= 'Lilly Fort ' as it's a string
Where class = 4;
Let's run it and see the result
Lilly Fort is updated as class teacher of grade 4
Similarly let update emailid of max ruin as [email protected]
So the syntax will be
Update student_table
Set email_id ='[email protected] '
Where std_id =2;
We can update 2 or more columns as well
Let's update class and marks of Emily Clare as 6 and 99
So the syntax will be
Update student_table
SET Class=6, Marks=99
Where Std_name= 'Emily Clare';
Let's run it and see the result
that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#mysql
#mysqldb
#mysqltutorials
#mysqltutorialforbeginners
#mysqlupdatecommand
#sqlupdatecommand
#updatedatawithsql
#updatetabledatainmysql
#mysqldatabasetutorial
#updatingadatabase
#addingtablestoadatabase
#insertintostatement
#updatequeryinsql
#mysqlupdatequery
#whatisupdateinmysql
#sqlupdate
#mysqlupdatestatement
#mysqldatabase
#mysqlcourse
#mysqldatabasetutorial
#mysqlcrashcourse
#mysqltutorialforbeginners
#learnmysql
#learnsql
#SqlDMLcommands
#createinsertupdateinsql
#sqlupdatequery
#sqlcommands
#sqlqueries
#structuredquerylanguage
#sqlinterviewquestions
#sqlbasics
#sqlforbeginners