mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-27 16:32:54 +00:00
7d506b3c5f
* feat: drop if exists Signed-off-by: tison <wander4096@gmail.com> * sqlness cases Signed-off-by: tison <wander4096@gmail.com> --------- Signed-off-by: tison <wander4096@gmail.com>
23 lines
349 B
Plaintext
23 lines
349 B
Plaintext
DROP TABLE IF EXISTS foo;
|
|
|
|
Affected Rows: 0
|
|
|
|
create table foo (
|
|
host string,
|
|
ts timestamp DEFAULT '2023-04-29 00:00:00+00:00',
|
|
cpu double default 0,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
) engine=mito with(regions=1);
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE IF EXISTS foo;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE IF EXISTS foo;
|
|
|
|
Affected Rows: 0
|
|
|