insert¶
Insert or append records to a table
Syntax: tname insert records
Where
tnameis a table name as a symbol atomrecordsis one or more records that match the table columns
inserts records into the table and returns the new row indexes.
q)show x:([a:`x`y];b:10 20)
a| b
-| --
x| 10
y| 20
q)`x insert (`z;30)
,2
q)x
a| b
-| --
x| 10
y| 20
z| 30
If the table is keyed, the new records must not match existing keys.
q)`x insert (`z;30)
'insert
Several records may be appended at once:
q)`x insert (`s`t;40 50)
3 4
q)x
a| b
-| --
x| 10
y| 20
z| 30
s| 40
t| 50
Function-local tables
insert can insert to global variables only, due to the lookup of the symbol name. If you need to insert to function-local tables, use table,:data instead.