mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-14 01:02:55 +00:00
26 lines
474 B
Plaintext
26 lines
474 B
Plaintext
CREATE TABLE test(i INTEGER, j TIMESTAMP TIME INDEX);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO test VALUES (1, 1), (2, 2);
|
|
|
|
Affected Rows: 2
|
|
|
|
ALTER TABLE test ADD COLUMN k INTEGER DEFAULT 3;
|
|
|
|
Affected Rows: 0
|
|
|
|
SELECT * FROM test;
|
|
|
|
+---+-------------------------+---+
|
|
| i | j | k |
|
|
+---+-------------------------+---+
|
|
| 1 | 1970-01-01T00:00:00.001 | 3 |
|
|
| 2 | 1970-01-01T00:00:00.002 | 3 |
|
|
+---+-------------------------+---+
|
|
|
|
DROP TABLE test;
|
|
|
|
Affected Rows: 0
|
|
|