Inserting multiple rows with insert statement?

Hey Friends,

If I try something like

INSERT INTO STUDENT (ID, NAME, CITY) 
VALUES (101,’Shubh’,’Kolkata’), 
       (102,’Sandeep’,’Asansol’), 
       (103,’Shouvik’,’Patna’);

I get

Exception: Syntax error at: ,

Darth

hi @darthseal ,

a time of writing inserting multiple rows in a single insert statement isn’t supported;
please refer to this page in the docs, that shows the actual sql capabilities of omnisci database

Anyway if you need to import data in bulk is better tu use the copy command