[MYSQL] MYSQL 테이블 수정하기

테이블 수정

필드 추가하기

ALTER TABLE 테이블명 ADD 추가할 필드명 AFTER 필드명 위치;

ALTER TABLE myMember ADD youGender enum('m','w','x') default 'x' comment "남성은 m, 여성은 w" AFTER youBirth;

mysql> desc myMember;
+------------+-------------------+------+-----+---------+----------------+
| Field      | Type              | Null | Key | Default | Extra          |
+------------+-------------------+------+-----+---------+----------------+
| myMemberID | int(10) unsigned  | NO   | PRI | NULL    | auto_increment |
| youEmail   | varchar(40)       | NO   |     | NULL    |                |
| youName    | varchar(12)       | NO   |     | NULL    |                |
| youPass    | varchar(20)       | NO   |     | NULL    |                |
| youBirth   | varchar(12)       | NO   |     | NULL    |                |
| youGender  | enum('m','w','x') | YES  |     | x       |                |
| regTime    | int(11)           | NO   |     | NULL    |                |
+------------+-------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)    

필드 수정하기

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

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| myMemberID | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| youName    | varchar(40)      | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

ALTER TABLE myMember02 MODIFY youName int(20);

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| myMemberID | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| youName    | int(20)          | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

필드 삭제하기

ALTER TABLE 테이블명 DROP 삭제할 필드명

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| myMemberID | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| youName    | int(20)          | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

ALTER TABLE myMember02 DROP youName; 

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| myMemberID | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
+------------+------------------+------+-----+---------+----------------+