Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • SQL Update Statement

    @mukesh.tomar
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 222
    Comment on it

    SQL Update statement is used to modify the records in table in database . We can modify either by change data or deleting data or to update the existing data .
    We can modify the rows based on condition and condition come with where clause .
    Syntax :

    1. update table_name set column_name = value1 ,............column_nameN = valueN , where clause ;

    Example :

    Table name : Employee_Info

    1.  Employee_name            Employee_Age          Employee _Salary
    2.       Mukesh                  23                           100000
    3.       Ayush                   24                           200000
    4.       Ishan                   20                           400000
    5.       Pranav                  35                           700000
    6.       Abhishek                26                           800000
    7.       Ravi                    25                           300000
    8.       David                   40                           800000

    If i want to update the salary of Mukesh then you can use below query :

    1. update Employee_Info set Employee_Salary = ' 900000 ' where Employee_name = ' Mukesh ' ;

    Output :

    1.  Employee_name            Employee_Age          Employee _Salary
    2.       Mukesh                  23                         **900000** // After updation
    3.       Ayush                   24                           200000
    4.       Ishan                   20                           400000
    5.       Pranav                  35                           700000
    6.       Abhishek                26                           800000
    7.       Ravi                    25                           300000
    8.       David                   40                           800000

    Using this statement we can update multiple column also , see below :

    1. update Employee_Info set Employee_Salary = ' 10,00000 ' , Employee_Age = ' 40 ' where Employee_name = ' Abhishek ' ;

    Output :

    1.  Employee_name            Employee_Age          Employee _Salary
    2.       Mukesh                  23                           100000
    3.       Ayush                   24                           200000
    4.       Ishan                   20                           400000
    5.       Pranav                  35                           700000
    6.       Abhishek                **40**                     **10,00000** // After updation
    7.       Ravi                    25                           300000
    8.       David                   40                           800000
    SQL Update Query
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: