DML - Change Name Column 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 the column name in mysql,,

this is structure table.. before it is manipulated :

Column : no
Type : int(10)
Null  : No
Key : Primary 

I will turn it into:

Column : NIP
Type : int(20)
Null : No
Key : Primary

With This Code or Query:

ALTER TABLE "Name Table" CHANGE "Current Name Column" "New Name Column"  INT("Integer Number") NOT NULL;

Example Code or Query on Image :

this is structure table.. after it is manipulated :

 There are also video tutorials :

by: wahyudev