UPDATE keyword is used to update the records already in the database. Where caluse should always be specifed to update the existing record as this may even create column or data lock.
Example
Update EMP_Database
Set EMP_NAME = 'Ramneek'
Where EMP_NAME='Rakesh'
This query will update EMP_NAME as Ramneek Where EMP_Name as Rakesh
Example
Update EMP_Database
Set EMP_NAME = 'Ramneek'
Where EMP_NAME='Rakesh'
This query will update EMP_NAME as Ramneek Where EMP_Name as Rakesh
No comments:
Post a Comment