5.16- What is Update Statement in sql | SQL Online Free Course | Microsoft Sql Server | Learn Sql

Published: 24 June 2021
on channel: TutorialsSpace- Er. Deepak Garg

2,708

5.16- What is Update Statement in sql | SQL Online Free Course | Microsoft Sql Server | Learn Sql

PLAYLIST:

Complete Playlist:

SQL - Structured Query Language By Using MSSQL In DBMS In Hindi
   • SQL - Structured Query Language By Using M...

(English)SQL using Microsoft SQL Server | Microsoft Sql Server
   • (English)SQL using Microsoft SQL Server | ...

DBMS - Data Base Management System Tutorials | All University Exams - UGC NET- GATE DBMS Lectures
   • DBMS Complete Syllabus- All University exa...

[With Notes & PDF File] | Database Management System In HINDI
   • [With Notes & PDF File] | Database Managem...

introduction to sql course,
learn sql tutorial,
sql quick tutorial,
sql coding tutorial,
sql server tutorial for beginners,
ms sql server tutorial for beginners,
order by asc, order by desc

dbms lectures,
dbms gate lectures in hindi,
gate dbms tutorials,
ugc net dbms tutorials,

#sqltutorials
#sqlonline
#sqlDBMS
#MSSQL#gatedbmslecturesinhindi,
#ugcnetdbmslecturesinhindi,
#gatedbmslectures,
#ugcnetdbmslectures,
#dbmslectures
#dbmstutorials

The SQL UPDATE Statement
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;

Note: Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!

UPDATE Table
The following SQL statement updates the first customer (CustomerID = 1) with a new contact person and a new city.

Example
UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;UPDATE Multiple Records
It is the WHERE clause that determines how many records will be updated.

The following SQL statement will update the ContactName to "Juan" for all records where country is "Mexico":

Example
UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';

Update Warning!
Be careful when updating records. If you omit the WHERE clause, ALL records will be updated!

Example
UPDATE Customers
SET ContactName='Juan'; Notes Link:
http://www.tutorialsspace.com/Downloa...

On this page of the site you can watch the video online 5.16- What is Update Statement in sql | SQL Online Free Course | Microsoft Sql Server | Learn Sql with a duration of hours minute second in good quality, which was uploaded by the user TutorialsSpace- Er. Deepak Garg 24 June 2021, share the link with friends and acquaintances, this video has already been watched 2,708 times on youtube and it was liked by 69 viewers. Enjoy your viewing!