ALTER

필드 추가하기

ALTER TABLE [테이블 이름] ADD [추가할 필드명] AFTER [필드 위치]

멤버 테이블에 핸드폰 번호 필드 추가

mysql>ALTER TABLE members ADD youPhone varchar(20) NOT NULL;
Query OK, 0 rows affected (0.14 sec)
Records: 0  Duplicates: 0  Warnings: 0

멤버 테이블에 주소를 생일 뒤에 추가

mysql>ALTER TABLE members ADD youAddress varchar(100) NOT NULL AFTER youBirth;
Query OK, 0 rows affected (0.12 sec)
Records: 0  Duplicates: 0  Warnings: 0

필드 수정하기

ALTER TABLE [테이블 이름] MODIFY [수정할 필드명]

핸드폰 필드 유형 수정하기

mysql>ALTER TABLE members MODIFY youPhone int(20) NOT NULL;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| memberID   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| youName    | varchar(10)      | NO   |     | NULL    |                |
| youPass    | varchar(10)      | NO   |     | NULL    |                |
| youAge     | int(5)           | NO   |     | NULL    |                |
| youBirth   | int(5)           | NO   |     | NULL    |                |
| youAddress | varchar(100)     | NO   |     | NULL    |                |
| regTime    | int(30)          | NO   |     | NULL    |                |
| youPhone   | int(20)          | NO   |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

필드 삭제하기

ALTER TABLE [테이블 이름] DROP [수정할 필드명]

주소 필드 삭제하기

mysql>ALTER TABLE members DROP youAddress;
Query OK, 0 rows affected (0.09 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc members;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| memberID | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| youName  | varchar(10)      | NO   |     | NULL    |                |
| youPass  | varchar(10)      | NO   |     | NULL    |                |
| youAge   | int(5)           | NO   |     | NULL    |                |
| youBirth | int(5)           | NO   |     | NULL    |                |
| regTime  | int(30)          | NO   |     | NULL    |                |
| youPhone | int(20)          | NO   |     | NULL    |                |
+----------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)