MySQL DDL statement (data definition language)

1.create database YXM; Create a database

2.drop database YXM; Deleting a database

3.create table YXM; Create a table

4.drop Table yxm;//Delete tables

5.alter Table YXM Modify Yname varchar (20); modifying table Types

6.alter table yxm Add column age int (3); Add Table field

7.alter table yxm drop column age; Delete a table field

8.alter table YXM Change age Age1 int (4);//Field rename

9.alter table YXM Add birth date after ename; Increase the date type's birth field behind the Ename field.

10.alter table YXM Modify age int (3) first; Modify the field age to put it in front.

11.alter table YXM Rename yxm1; Change the table name Yxm to YXM1.

MySQL DDL statement (data definition language)