Versions Compared

Version Old Version 1 New Version Current
Changes made by

Ryan Park (Unlicensed)

Grey Shim

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Ui text box

Index

Table of Contents
maxLevel3
indent30px
exclude목차
classtoc

Creating Log Table

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

Code Block
languagesql
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.

Code Block
languagesql
Mach> DROP TABLE sensor_data;
Dropped successfully.

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