Update Query in MySql

Update Query
-------------------
                     
                     --> You can update more one column value together.

                     --> You can give any condition using [where clause].

Syntax to update in mysql
-----------------------------------
Update 
                 Table-Name 
Set 
                 Column-Name1 = "Value1", 
                 Column-Name2 = "Value2" 
 
                  [where clause];
 -------------------------------------------------
Updating data in MySql command Line.
 ------------------------------------------------
Update
                Student_Details
Set
                Username = "Selva",
                Password = "Selva"
Where
               role="Student" and studid = "SBO04";
 ------------------------------------------------
1 row(s) affected

Execution Time : 0.001 sec
Transfer Time  : 0 sec
Total Time     : 0.002 sec
---------------------------------------------------
            

 This may helpful to someone...