缺少 alter column 的描述

[okJiang]

Change Request

This repository is ONLY used to solve problems related to DOCS-CN.
For other issues (TiDB, TiKV, etc), please move to other repositories.

Please answer the following questions before submitting your issue. Thanks!

1. Describe what you find is inappropriate or missing in the existing docs.

缺少 alter column 的描述，mysql 官方是有的

tidb 也是支持的

mysql> show create table t;
+-------+----------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                             |
+-------+----------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `a` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> alter table t alter column set default 2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 30 near "set default 2" 
mysql> alter table t alter column a set default 2;
Query OK, 0 rows affected (0.15 sec)

mysql> show create table t;
+-------+----------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                             |
+-------+----------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `a` int(11) DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                   |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v7.6.0-alpha-599-g24fcf71e7e-dirty
Edition: Community
Git Commit Hash: 24fcf71e7e3419ae5d6064ff2ba6df370fa70574
Git Branch: bdr-bwlist-2
UTC Build Time: 2023-12-27 07:25:23
GoVersion: go1.21.0
Race Enabled: false
Check Table Before Drop: false
Store: tikv |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

2. Describe your suggestion or addition.

补充上

3. Provide some reference materials (documents, websites, etc) if you could.

https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

[Oreoxmt]

在 ALTER TABLE 语法图中有体现 ALTER COLUMN https://docs.pingcap.com/zh/tidb/stable/sql-statement-alter-table
请 @xhebox 看看是否需要在 ALTER TABLE 文档中添加 ALTER COLUMN 示例？

[okJiang]

主要是在文档里搜索也搜索不到😬

[xhebox]

请 @xhebox 看看是否需要在 ALTER TABLE 文档中添加 ALTER COLUMN 示例？

我觉得都可.