- 추가
Alter Table tableName Add fieldName fieldtype;
- 삭제
Alter Table tableName Drop fieldName;
예제)
mysql> alter table SRC_IP add ttl int(3);
Query OK, 197662 rows affected (2.85 sec)
Records: 197662 Duplicates: 0 Warnings: 0
mysql> alter table SRC_IP add ping_time int(10);
Query OK, 197662 rows affected (2.84 sec)
Records: 197662 Duplicates: 0 Warnings: 0
