table

README

Insert data into GreptimeDB

Insert

go run main.go

Output:

2024/11/13 19:39:37 affected rows: 3
2024/11/13 19:39:37 affected rows: 1
2024/11/13 19:39:37 affected rows: 1
2024/11/13 19:39:37 affected rows: 3
2024/11/13 19:39:37 affected rows: 1
2024/11/13 19:39:37 affected rows: 1

Query

$ mysql -h 127.0.0.1 -P 4002 public

mysql> select * from monitors_with_schema;
+------+-------+-------------+----------------------------+
| id   | host  | temperature | timestamp                  |
+------+-------+-------------+----------------------------+
|    1 | hello |         1.1 | 2024-11-13 11:39:37.237320 |
|    1 | hello |         1.1 | 2024-11-13 11:39:37.417887 |
|    2 | hello |         2.2 | 2024-11-13 11:39:37.237320 |
|    2 | hello |         2.2 | 2024-11-13 11:39:37.417887 |
|    3 | hello |         3.3 | 2024-11-13 11:39:37.237320 |
|    3 | hello |         3.3 | 2024-11-13 11:39:37.417887 |
+------+-------+-------------+----------------------------+
6 rows in set (0.03 sec)