http://qs321.pair.com?node_id=26456


in reply to How can I allow the user to enter multiple rows of data?

Russ's solution seems to accomplish this by having the MySQL insert the records one at a time. I know MySQL has a feature that let's you do an Insert of multiple rows with one statement.

How do you accomplish that.

  • Comment on Re: How can I allow the user to enter multiple rows of data?

Replies are listed 'Best First'.
RE: Answer: How can I allow the user to enter multiple rows of data?
by Russ (Deacon) on Aug 07, 2000 at 05:19 UTC
    I didn't find any way to insert multiple rows at once, other than the LOAD DATA INFILE syntax.

    Note: I am running an archaic version of MySQL, just like the old 5.005_57 version of Perl, because I am too lazy to keep it up-to-date. If there is a newer, better way in the recent versions, feel free to post it. I'd love to know about it. :-)

    Russ
    Brainbench 'Most Valuable Professional' for Perl

[reply]

In Section Seekers of Perl Wisdom