[MySQL] Data Definition Language (DDL)

---

Today We are going to study DDL. It include CREATE, ALTER, DROP, RENAME and TRUNCATE. 

So Let's get it.

---

Create table, We maed a table called test3.

Drop table, It's easy just type it.

 

alter table tablename add tel int; 

 

 

alter table name drop tel;

 

 

alter table tablename modify tel int; , this is mean that modify column attribute.

 

 

 

 

alter table tablename change tel pongpong varchar(45); As you know We can see from tel to pongpong. 

 

---

 

 

 

To be continue