UPDATE & DELETE COMMAMDS IN SQL || UPDATE || DELETE || DML COMMANDS || SQL COMMANDS || SQL || DBMS
HTML-код
- Опубликовано: 8 сен 2024
- UPDATE COMMAND
Syntax
update table_name where condition
DELETE COMMAND
Syntax-1
delete from table_name where condition
Syntax-2
delete from table_name
-------------------------------------------------------------------------------------------------
HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10
• HOW TO DOWNLOAD & INST...
DATABASE MANAGEMENT SYSTEM
• DATABASE MANAGEMENT SY...
PYTHON PROGRAMS
• PYTHON PROGRAMS
C PROGRAMMING
• 01 - VARIABLES & CONST...
CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
• CORE JAVA TUTORIAL FOR...
HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
• HTML TUTORIALS WITH IM...
LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
• LEARN CSS IN 3 HOURS |...
JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
• JAVA SCRIPT FOR BEGINN...
PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
• Python in One Shot(తెల...
PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
• PYTHON - OOPS CONCEPTS...
PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
• PYTHON NUMPY TUTORIAL ...
PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
• PYTHON PANDAS TUTORIAL...
MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
• MATPLOTLIB LIBRARY - P...
PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
• PYTHON DATABASE CONNEC...
DATA STRUCTURES USING PYTHON (ENGLISH)
• DATA STRUCTURES USING ...
----------------------------------------------------------------------------------------------
Instagram : / sundeepsaradhikanthety
Super sir proceeds for further videos
now i can defend my answers in xzams
thank you sir 😇😇
super sir ,
please upload further vides for sql
Thanku sir😀
Sir, can't we update percentage column at a time with multiple conditions like percentage>60 as Pass,percentage>70 as First class,percentage between 80 and 90 as distinction ????
Hi try with this
update table_name
set column= case
when percentage>80 and percentage 70 and percentage60 and percentage
@@sundeepsaradhi ok sir...
If we want to change that two hari's percentage with a single query then what would be the query sir?
Dear sir,
I'm K.Revanth Reddy studying now in 3rd year cse of r18 regulation. I've got 30 credits upto my 2-1 semester. Recently, I've completed my 2-2 exams. I'm going to write my 1-2 supplementary exams in November. Is it better to write 1-1 supplementary exams also with them. If there is credit detention. Will I be detented. Please, give me a clarity sir. 🙏🏻 🙏🏻🙏🏻🙏🏻
About credit detention you need to refer your university regulation and it differs from one university to others
How we select database
can u turn on sub title
How can get table
Both truncate and delete commands usage is same then y we use both