12. UPDATE IN SQL | SQL TUTORIAL
In this video, learn how to use the UPDATE statement in SQL to modify existing data in your tables. 🛠️📋
✅ What is the UPDATE Statement?
The UPDATE command allows you to modify one or more rows in a table based on specific conditions.
Want more similar videos- hit like, comment, share and subscribe
❤️Do Like, Share and Comment ❤️
❤️ Like Aim 5000 likes! ❤️
➖➖➖➖➖➖➖➖➖➖➖➖➖
script
CREATE TABLE EMPL (
ID INT,
NAME VARCHAR (17),
SALARY INT,
LOCATION VARCHAR(17),
DEPT VARCHAR(17)
)
INSERT INTO EMPL VALUES (1,'MANISH', 900000,'INDIA','SDE')
INSERT INTO EMPL VALUES (2,'RANI', 1000000,'INDIA','SDE2')
INSERT INTO EMPL (ID ,NAME,SALARY,DEPT) VALUES (3,'RAJ', 700000,'SALES')
INSERT INTO EMPL(ID ,NAME,SALARY,DEPT) VALUES (4,'RAHUL', 600000,'HR')
INSERT INTO EMPL(ID ,NAME,DEPT) VALUES (5,'RAj','HR')
INSERT INTO EMPL(ID ,NAME,DEPT) VALUES (6,'shyam','HR')
➖➖➖➖➖➖➖➖➖➖➖➖➖
AWS DATA ENGINEER : • AWS DATA ENGINEER
Azure data factory :
• Azure Data Factory
Azure data engineer playlist : • Azure Data Engineer
SQL PLAYLIST : • SQL playlist
PYSPARK PLAYLIST -
• Pyspark Tutorial
➖➖➖➖➖➖➖➖➖➖➖➖➖
📣Want to connect with me? Check out these links:📣
Join telegram to discuss https://t.me/+Cb98j1_fnZs3OTA1
➖➖➖➖➖➖➖➖➖➖➖➖➖
what we have covered in this video:
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this video and learned something new :)
See you in next video, until then Bye-Bye!
➖➖➖➖➖➖➖➖➖➖➖➖➖