INSERT keyword

Inserts data into a database table.

Syntax

Examples

Inserting all columns

INSERT INTO trades

VALUES(

to_timestamp('2019-10-17T00:00:00', 'yyyy-MM-ddTHH:mm:ss'),

'AAPL',

255,

123.33,

'B');

Specifying schema

INSERT INTO trades (timestamp, symbol, quantity, price, side)

VALUES(

to_timestamp('2019-10-17T00:00:00', 'yyyy-MM-ddTHH:mm:ss'),

'AAPL',

255,

123.33,

'B');

note

Columns can be omitted during INSERT in which case value will be NULL

Inserting only specific columns

INSERT INTO trades (timestamp, symbol, price)

VALUES(to_timestamp('2019-10-17T00:00:00', 'yyyy-MM-ddTHH:mm:ss'),'AAPL','B');

Inserting query results

Insert as select

INSERT INTO confirmed_trades

SELECT timestamp, instrument, quantity, price, side

FROM unconfirmed_trades

WHERE trade_id = '47219345234'

;

note

This method allows you to insert several rows at once (as many as your query returns).