This is an automated email from the ASF dual-hosted git repository.
critas pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new 49bdfe39 add alter table add field example (#939)
49bdfe39 is described below
commit 49bdfe39b222e4ed452974cc3448abcc22c1a5c4
Author: leto-b <[email protected]>
AuthorDate: Fri Dec 26 11:14:51 2025 +0800
add alter table add field example (#939)
---
src/UserGuide/Master/Table/Basic-Concept/Table-Management.md | 1 +
src/UserGuide/latest-Table/Basic-Concept/Table-Management.md | 1 +
src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management.md | 1 +
src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management.md | 1 +
4 files changed, 4 insertions(+)
diff --git a/src/UserGuide/Master/Table/Basic-Concept/Table-Management.md
b/src/UserGuide/Master/Table/Basic-Concept/Table-Management.md
index 752c6cae..20caa49b 100644
--- a/src/UserGuide/Master/Table/Basic-Concept/Table-Management.md
+++ b/src/UserGuide/Master/Table/Basic-Concept/Table-Management.md
@@ -280,6 +280,7 @@ ALTER TABLE (IF EXISTS)? tableName=qualifiedName ADD COLUMN
(IF NOT EXISTS)? col
```SQL
ALTER TABLE tableB ADD COLUMN IF NOT EXISTS a TAG
+ALTER TABLE tableB ADD COLUMN IF NOT EXISTS b FLOAT FIELD COMMENT 'b'
ALTER TABLE tableB set properties TTL=3600
COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
diff --git a/src/UserGuide/latest-Table/Basic-Concept/Table-Management.md
b/src/UserGuide/latest-Table/Basic-Concept/Table-Management.md
index d256eed3..d97e7e58 100644
--- a/src/UserGuide/latest-Table/Basic-Concept/Table-Management.md
+++ b/src/UserGuide/latest-Table/Basic-Concept/Table-Management.md
@@ -281,6 +281,7 @@ ALTER TABLE (IF EXISTS)? tableName=qualifiedName ADD COLUMN
(IF NOT EXISTS)? col
```SQL
ALTER TABLE tableB ADD COLUMN IF NOT EXISTS a TAG
+ALTER TABLE tableB ADD COLUMN IF NOT EXISTS b FLOAT FIELD COMMENT 'b'
ALTER TABLE tableB set properties TTL=3600
COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
diff --git a/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management.md
b/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management.md
index f211ae9f..2e194df9 100644
--- a/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management.md
+++ b/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management.md
@@ -287,6 +287,7 @@ ALTER TABLE (IF EXISTS)? tableName=qualifiedName ADD COLUMN
(IF NOT EXISTS)? col
```SQL
ALTER TABLE tableB ADD COLUMN IF NOT EXISTS a TAG COMMENT 'a'
+ALTER TABLE tableB ADD COLUMN IF NOT EXISTS b FLOAT FIELD COMMENT 'b'
ALTER TABLE tableB set properties TTL=3600
COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
diff --git a/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management.md
b/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management.md
index 8ac08474..23b9cf79 100644
--- a/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management.md
+++ b/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management.md
@@ -287,6 +287,7 @@ ALTER TABLE (IF EXISTS)? tableName=qualifiedName ADD COLUMN
(IF NOT EXISTS)? col
```SQL
ALTER TABLE tableB ADD COLUMN IF NOT EXISTS a TAG COMMENT 'a'
+ALTER TABLE tableB ADD COLUMN IF NOT EXISTS b FLOAT FIELD COMMENT 'b'
ALTER TABLE tableB set properties TTL=3600
COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
