@ 테이블만들기 - 테이블 이름 : test
mysql> create table test(a int,b char(20));
Query OK, 0 rows affected (0.09 sec)
mysql> desc test;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)
@
테이블 이름 바꾸기 - 바꿀 이름 : test2
mysql>
alter table test rename as test2;
Query OK, 0 rows affected (0.00 sec)
mysql> desc test2;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)
@ 필드추가하기 : c 필드추가
mysql> alter table test2 add c int;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test2;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
| c | int(11) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.00 sec)
@ 필드추가 - 원하는 위치에삽입하기 (mysql 버젼 3.22 이후 버젼만
지원)
mysql> alter table test2 add d int after a;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test2;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| d | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
| c | int(11) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.00 sec)
@ 필드삭제 - d 필드 삭제하기
mysql> alter table test2 drop d;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test2;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
| c | int(11) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.00 sec)
@ 필드 속성 바꾸기 - c 필드를 이름 d 로 바꾸고 타입을 char로 바꾸기
mysql> alter table test2 change c d char;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test2;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
| d | char(1) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.01 sec)
@ d 필드의 타입을 int로 바꾸기
mysql> alter table test2 change d d int;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc test2;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default
| Extra |
+-------+----------+------+-----+---------+-------+
| a | int(11) | YES | |
NULL | |
| b | char(20) | YES | |
NULL | |
| d | int(11) | YES | |
NULL | |
+-------+----------+------+-----+---------+-------+
3 rows in set (0.00 sec)
|
|
