Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: How to make many insert-statement

How to make many insert-statement 3 months 10 hours ago #18856

  • Gloem
  • Gloem's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
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?

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

How to make many insert-statement 3 months 1 hour ago #18857

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7453
  • Karma: 33
  • Thank you received: 399
There are multiple ways of doing it

For example, you can use SQL Delimiter.

Attachments:

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

Mike
  • Page:
  • 1

We have 273 guests and no members online