Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: dbi style questions (code, discussion)

by talexb (Chancellor)
on Dec 29, 2001 at 08:02 UTC ( [id://135059]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $sth = $dbh -> prepare("insert into table1 (col1, col2, col2) value
    +s (?, ?, ?)");
    
  2. or download this
    my $sth = $dbh->prepare(
      "insert into table1 (col1, col2, col2) values (?, ?, ?)");
    
  3. or download this
    my $updater = $dbh -> prepare("update table1 set col1 = ?, col2 = ?, c
    +ol3 = ? where col1 = ? and col2 = ? and col3 = ?");
    
  4. or download this
    my $updater = $dbh -> prepare(
    "update table1 set col1 = ?,    col2 = ?,    col3 = ? \
                 where col1 = ? and col2 = ? and col3 = ?");
    
  5. or download this
    my $updater = $dbh->prepare(
    "update table1 set col1 = ?, col2 = ?, col3 = ? where id = $ID");
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (2)
As of 2024-04-19 21:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found