Inserting multiple rows with insert statement?

Follow

David Seal

• January 31, 2021 19:25

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

0

• Official comment

  

  Neill Lewis

  • December 21, 2022 19:57

  Please note that as of HEAVY.AI v6.1.0 multiple insertion is supported. Example using provided data is below.

   

  CREATE TABLE student (
    id INTEGER,
    name TEXT ENCODING DICT(32),
    city TEXT ENCODING DICT(32));
  
  
  
  INSERT INTO
    STUDENT (ID, NAME, CITY)
  VALUES
    (101, 'Shubh', 'Kolkata'),
    (102, 'Sandeep', 'Asansol'),
    (103, 'Shouvik', 'Patna');

  Comment actions Permalink
• 

  Candido Dessanti

  • February 01, 2021 07:37

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.