import

Inserts new records into the specified table. Administrative privileges are required to execute this command.

Syntax

import [create=BOOL] TABLE
Required Parameters
TABLE
Name of table in which to store the data.
Optional Parameters
create=BOOL
Option to enable the creation of the table with the given name, TABLE (default: f).
  • t: Enables the creation of the table with the given name if there is no table.
  • f: Disables the creation of the table with the given name if there is no table. The query fails unless the table exists.

Usage

Import the entire sys_cpu_logs data into old_sys_cpu_logs.

table order=asc sys_cpu_logs 
| import create=t old_sys_cpu_logs