Update Specific Rows In MySQL Tutorial Example

How To Update Specific Rows In MySQL Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to update specific rows from a database table "test" in MySQL Database Server

-- How To Update Specific Rows In MySQL Tutorial Example

UPDATE test SET TestID=11 WHERE TestName='Noor.Hasan';

-- that's it!! TestID column of all rows of mysql database table "test" have/has been updated
-- whose TestName value is "Noor.Hasan"

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Update Specific Rows In MySQL Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL NULLIF() Function NULL Value Example
2. MySQL IFNULL() Function Datetime Example
3. MySQL IFNULL() Nested Function Example
4. MySQL IFNULL() Function String Example
5. MySQL IFNULL() Function Number Example
6. MySQL TRUNCATE TABLE Example
7. MySQL Stored Procedure: Batch Salary Increment Example
8. MSSQL PRINT Like Function in MySQL Example
9. 20 steps to make CakePHP Blog Project