Day 4 : SQL Tutorial in Hindi

Опубликовано: 12 Февраль 2022
на канале: Rita Jain

126

#ritajainlectures #sqltutorialInHiindi #updatecommand
What we will Learn :
0:00 1 Introduction
5:00 2 Modifying data into the table using update command
10:00 3 Condition Based on Range using “Between” operator
15:00 4 Condition Based on a List using “In” operator
17:00 5 Condition Based on Pattern Match using “Like” operator
20:00 6 Deleting Data from the tables
25:00 7 summary
30:00 8 About Day 5 lecture

Important queries
MODIFYING DATA IN TABLES
you can modify data in tables using UPDATE command of SQL. The UPDATE command specifies the rows to be changed
using the WHERE clause, and the new data using the SET keyword. Syntax of update command is :
UPDATE tablename
SET columnname=value , columnname=value
WHERE condition ;

DELETING DATA FROM TABLES
To delete some data from tables, DELETE command is used. The DELETE command removes rows from a table. The
syntax of DELETE command is :
DELETE FROM tablenameWHERE condition
Between operator
SELECT ECODE , ENAME ,GRADE
FROM EMPLOYEE
WHERE GROSS BETWEEN 40000 AND 50000
Play list Lin for SQL tutorial in Hindi
• SQL 5 Days Tutorial in Hindi

channel link
/ @jainrita