Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Multiple SQL statements

by Wookie (Beadle)
on Jul 19, 2001 at 14:19 UTC ( [id://98023]=note: print w/replies, xml ) Need Help??


in reply to Multiple SQL statements

On Sybase, just splitting such statements with a new line seemed to work fine. I'm not too familiar with mysql - but unless you would normally use the ';' command terminator when you are running one command - then it looks to me like it won't help with multiple commands.

Here's some sample code for Sybase anyway - hope this might help a little:
#!/usr/bin/perl -w use DBI; use strict; my $foo=DBI->connect('DBI:Sybase:server=FOO', user, pass)||die "Connec +tion Failed! $DBI::errstr\n"; my $sql="CREATE TABLE dbo.foo\n(bar int NOT NULL)\nCREATE TABLE dbo.fo +otoo\n(bar int NOT NULL)"; my $fooexec=$foo->prepare($sql); $fooexec->execute()||die "SQL failed: $!\n"; $fooexec->finish(); $foo->disconnect(); exit (0);
UPDATE: Thanks bobione - fixed that problem :)
game(Wookie,opponent) eq 'Wookie' ? undef $problem : remove_limbs(arms,opponent);

Replies are listed 'Best First'.
Re: Re: Multiple SQL statements
by bobione (Pilgrim) on Jul 19, 2001 at 18:58 UTC
    Hi, just a rectification ?!

    Isn't it $foo instead of $daffy ?
    It seems to be a "cut/past" error.

    BobiOne KenoBi ;)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2025-03-17 07:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    When you first encountered Perl, which feature amazed you the most?










    Results (54 votes). Check out past polls.