How to make many insert-statement

  • Posts: 1
  • Thank you received: 0

How to make many insert-statement was created by Gloem

Hi, I have approx. 500 inserts which look like

INSERT INTO HIV (PROJEKT, VIDEO, BESCHREIBUNG) VALUES ('2', '01207', '22H0270-20180531')
INSERT INTO HIV (PROJEKT, VIDEO, BESCHREIBUNG) VALUES ('2', '01208', '22H0280-20180531')
INSERT INTO HIV (PROJEKT, VIDEO, BESCHREIBUNG) VALUES ('2', '01209', '22H0300-20180531')
...

How can I insert this in one statement or batch?
2 years 11 months ago #18856

Please Log in or Create an account to join the conversation.

  • Posts: 8321
  • Karma: 33
  • Thank you received: 545

Replied by admin on topic How to make many insert-statement

There are multiple ways of doing it

For example, you can use SQL Delimiter.

Mike
ETL Architect
2 years 11 months ago #18857
Attachments:

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies