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

TOPIC: How to make many insert-statement

How to make many insert-statement 5 months 1 day ago #18856

  • Gloem
  • 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 5 months 20 hours ago #18857

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

For example, you can use SQL Delimiter.

Mike
Attachments:

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

  • Page:
  • 1

We have 1225 guests and no members online