All Products
Search

This Product

    Time Series Database:Multiple Statements

    Document Center

    Time Series Database:Multiple Statements

    Last Updated:Aug 05, 2020

    Use semicolons (;) to separate SELECT statements in a query.

    Example

    CLI

    The following example shows how to separate SELECT statements if you use the command-line interface (CLI) of TSDB for InfluxDB®.

    1. > SELECT MEAN("water_level") FROM "h2o_feet"; SELECT "water_level" FROM "h2o_feet" LIMIT 2
    3. name: h2o_feet
    4. time                   mean
    5. ----                   ----
    6. 1970-01-01T00:00:00Z   4.442107025822522
    8. name: h2o_feet
    9. time                   water_level
    10. ----                   -----------
    11. 2015-08-18T00:00:00Z   8.12
    12. 2015-08-18T00:00:00Z   2.064

    HTTP API

    The following example shows how to use the HTTP API of TSDB for InfluxDB®.

    1. {
    2.     "results": [
    3.         {
    4.             "statement_id": 0,
    5.             "series": [
    6.                 {
    7.                     "name": "h2o_feet",
    8.                     "columns": [
    9.                         "time",
    10.                         "mean"
    11.                     ],
    12.                     "values": [
    13.                         [
    14.                             "1970-01-01T00:00:00Z",
    15.                             4.442107025822522
    16.                         ]
    17.                     ]
    18.                 }
    19.             ]
    20.         },
    21.         {
    22.             "statement_id": 1,
    23.             "series": [
    24.                 {
    25.                     "name": "h2o_feet",
    26.                     "columns": [
    27.                         "time",
    28.                         "water_level"
    29.                     ],
    30.                     "values": [
    31.                         [
    32.                             "2015-08-18T00:00:00Z",
    33.                             8.12
    34.                         ],
    35.                         [
    36.                             "2015-08-18T00:00:00Z",
    37.                             2.064
    38.                         ]
    39.                     ]
    40.                 }
    41.             ]
    42.         }
    43.     ]
    44. }


    InfluxDB® is a trademark registered by InfluxData, which is not affiliated with, and does not endorse, TSDB for InfluxDB®.