Update;-this command is used to update the table column and the data present in the table.
if you want to update the existing table or data present in the table use update command.
Ex;-
in this we update the name to "abc" where id =1.
Ex;-in this we update the age to 60 whose id is greater than 2.
Ex:-if we do not use where clause and write the update command so it update all the rows which is the drawback of update command.so if you want to update any particular row you must use where clause like this.
if you want to update the existing table or data present in the table use update command.
Ex;-
in this we update the name to "abc" where id =1.
Ex;-in this we update the age to 60 whose id is greater than 2.
Ex:-if we do not use where clause and write the update command so it update all the rows which is the drawback of update command.so if you want to update any particular row you must use where clause like this.
No comments :
Post a Comment