DML - Change Name Records use CMD - Amazing Indonesia

Latest

Saturday 11 February 2012

DML - Change Name Records use CMD

Add, change, delete, including Data Manipulation Language (DML) on sql query, in this tutorial I will give one example DML code, that is, change name records in mysql..

this is structure table.. before it is manipulated :


on the column name, contains : Wahyudi
I would change its name to : Wildan

With Code Query :

UPDATE "Name Table" SET "Name Column" = 'Wildan' WHERE "Name Column Primary" =1;

Example Code Query on Image :

  
 this is structure table.. after it is manipulated :


There are also video tutorials :


by: wahyudev  

No comments:

Post a Comment