Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Current »

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.

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.
  • No labels