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)