Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Answer: How can I allow the user to enter multiple rows of data?

by rodry (Beadle)
on Aug 07, 2000 at 01:39 UTC ( #26456=categorized answer: print w/replies, xml ) Need Help??

Q&A > CGI programming > How can I allow the user to enter multiple rows of data? - Answer contributed by rodry

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 Answer: 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

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2020-09-20 03:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If at first I donít succeed, I Ö










    Results (117 votes). Check out past polls.

    Notices?