ALERT can be used to modify any table settings or data within the table:
- Add/Drop a column
- Rename a table
ALTER TABLE [db.]table [ADD COLUMN name type ... | DROP COLUMN name | RENAME name ]
Adds a new column to the table:
ALTER TABLE monitor ADD COLUMN load_15 double;
Definition of column is the same as in CREATE.
Removes a column from the table:
ALTER TABLE monitor DROP COLUMN load_15;
The removed column can't be retrieved immediately by all subsequent queries.
Renames the table:
ALTER TABLE monitor RENAME monitor_new;
This command only renames the table; it doesn't modify the data within the table.