insert into

insert into
  table_name1
  values (X, [Y, ...]) | select col_name(s) from table_name2

t=table(`XOM`GS`FB as ticker, 100 80 120 as volume);
t;

insert into t values(`GOOG, 200);
t;

insert into t values(`AMZN`NFLX, 300 250);
t;

insert into t values(('AMD','NVDA'), (60 400));
t;

The above code example can also be written in a way that follows the ANSI SQL standard for inserting multiple rows into the table directly. This alternative approach yields the same result.

insert into t values ('AMD', 60), ('NVDA', 400);
t;

To only insert values for a subset of columns:

insert into t(ticker, volume) values(`UBER`LYFT, 0 0);
t;