COMMENT TABLE
描述
COMMENT TABLE 语句用于给表添加评论。
语法
COMMENT TABLE ( table_identifier | WITH ID table_id )Parameter
table_identifier
指定被删除的表名，可以选择使用数据库名进行限定。
语法:
[ database_name. ] table_nametable_id
指定被删除的表的 ID，表的 ID 可以通过
SHOW TABLES等语句查询。
示例
-- 假设存在一个名为 `employeetable` 的被删除的表。
SHOW TABLES DROPPED;
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
|database| tableName|tableType|tableId|size| createdAt| deletedAt|isShared|isDeleted|description|
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
| default|employeetable| table| 1| 20|2024-10-10 19:27:...|2024-10-10 19:28:...| false| true| |
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
-- 恢复此表
COMMENT TABLE employeetable;
-- 确认被恢复
SHOW TABLES DROPPED;
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
|database|tableName|tableType|tableId|size|createdAt|deletedAt|isShared|isDeleted|description|
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
-- 删除表
DROP TABLE employeetable;
SHOW TABLES DROPPED;
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
|database| tableName|tableType|tableId|size| createdAt| deletedAt|isShared|isDeleted|description|
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
| default|employeetable| table| 1| 20|2024-10-10 19:27:...|2024-10-10 19:28:...| false| true| |
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
-- 使用 ID 恢复表
COMMENT TABLE WITH ID 1;
-- 确认被恢复
SHOW TABLES DROPPED;
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
|database|tableName|tableType|tableId|size|createdAt|deletedAt|isShared|isDeleted|description|
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+