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

Комментарии • 14

  • @saiaddepalli254
    @saiaddepalli254 2 года назад +2

    Super sir proceeds for further videos

  • @BiqSam2002
    @BiqSam2002 9 месяцев назад

    now i can defend my answers in xzams
    thank you sir 😇😇

  • @thamatapusatyanarayana454
    @thamatapusatyanarayana454 2 года назад

    super sir ,
    please upload further vides for sql

  • @navrajsingh2300
    @navrajsingh2300 2 года назад +1

    Thanku sir😀

  • @uchiha_sasuke_48
    @uchiha_sasuke_48 2 года назад +1

    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 ????

    • @sundeepsaradhi
      @sundeepsaradhi  2 года назад +1

      Hi try with this
      update table_name
      set column= case
      when percentage>80 and percentage 70 and percentage60 and percentage

    • @uchiha_sasuke_48
      @uchiha_sasuke_48 2 года назад

      @@sundeepsaradhi ok sir...

  • @vivethavive5765
    @vivethavive5765 Год назад

    If we want to change that two hari's percentage with a single query then what would be the query sir?

  • @just_reva_things_616
    @just_reva_things_616 2 года назад +1

    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. 🙏🏻 🙏🏻🙏🏻🙏🏻

    • @sundeepsaradhi
      @sundeepsaradhi  2 года назад

      About credit detention you need to refer your university regulation and it differs from one university to others

  • @cherukurisony7512
    @cherukurisony7512 Год назад

    How we select database

  • @phanminhvuongk16_hcm23
    @phanminhvuongk16_hcm23 2 года назад

    can u turn on sub title

  • @cherukurisony7512
    @cherukurisony7512 Год назад

    How can get table