mysql table / column(type) 변경

◆ 테이블 이름 변경

mysql> alter table 현재_테이블_이름 rename 새로운_테이블_이름;

mysql> show tables;

+----------------+

| Tables_in_oops |

+----------------+

| old_table |

+----------------+

1 row in set (0.00 sec)

mysql>

mysql> alter table old_table rename new_table;

Query OK, 0 rows affected (0.00 sec)

mysql>

mysql> show tables;

+----------------+

| Tables_in_oops |

+----------------+

| new_table |

+----------------+

1 row in set (0.00 sec)

mysql>

◆ 테이블 컬럼 이름 변경

mysql> alter table 테이블_이름 change 현재_컬럼_이름 새로운_컬럼_이름 타입;

mysql> desc new_table;

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

mysql> alter table new_table change name title varchar(16);

Query OK, 0 rows affected (0.00 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> desc new_table;

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

mysql>

◆ 테이블 컬럼 타입 변경

mysql> alter table 테이블_이름 modify 컬럼명 변경_타입;

mysql> desc new_table;

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

mysql>

mysql> alter table new_table modify title varchar(50);

Query OK, 0 rows affected (0.00 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> desc new_table;

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

mysql>