Update Data In MySQL Tutorial Example

How To Update Data In MySQL Tutorial Example

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

-- How To Update Data In MySQL Tutorial Example

UPDATE test SET TestAge=99;

-- that's it!! TestAge column of all rows of mysql database table "test" have been updated

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

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

 

Related Tutorial Examples

1. MySQL Sub-Query: CREATE TABLE SELECT... Example
2. MySQL Sub-Query: CREATE TABLE SELECT *... Example
3. MySQL NULLIF() Nested Function Example
4. MySQL NULLIF() Function Datetime Value Example
5. MySQL NULLIF() Function String Value Example
6. MySQL NULLIF() Function Number Value Example
7. MySQL NULLIF() Function Boolean Value Example
8. MySQL Stored Procedure: Variable Example
9. 20 steps to make CakePHP Blog Project