Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: DBI:mysql

by peppiv (Curate)
on Apr 15, 2002 at 13:05 UTC ( #159157=note: print w/replies, xml ) Need Help??


in reply to DBI:mysql

I would try using placeholders. Especially when you know that you're inserting four data fields every time. Makes it easy. Check out this

peppiv

Replies are listed 'Best First'.
Re: Re: DBI:mysql
by Dalin (Sexton) on Apr 15, 2002 at 13:15 UTC
    If you check out the q_marks sub, you'll see that I'm inserting the proper amount of place holders for each data line. the $dbh->trace is confirming that the sub is working correctly. I'm not including column names in the insert statement because each data line has the proper amount of fields for each table I'm inserting into. I know this because the data files are direct dumps from a previous dbase.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://159157]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2021-06-19 21:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What does the "s" stand for in "perls"? (Whence perls)












    Results (93 votes). Check out past polls.

    Notices?