/
Creating and Managing Log Table

Creating and Managing Log Table

Owned by Daniel Kim (Unlicensed)
Feb 22, 2023

The log table can be simply generated as follows. Let's create a table called sensor_data and delete it.

Data types compatible with Machbase can be found in the SQL Reference Types.

Index

Creating Log Table

Create a log table with the 'CREATE TABLE' syntax.

Mach> CREATE TABLE sensor_data
      (
      	  id VARCHAR(32),
          val DOUBLE
       );
Created successfully.

Mach> DROP TABLE sensor_data;
Dropped successfully.


Deleting Log Table

Delete log table with 'DROP TABLE' statement.

Mach> DROP TABLE sensor_data;
Dropped successfully.

-- TRUNCATE deletes only data and keeps table.
Mach> TRUNCATE TABLE sensor_data;
Truncated successfully.

Related content