Re: update command
David Dick <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl,gmane.comp.lang.perl.active-perl,gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
Presumably you remembered to include
Eko Budiharto wrote:
> Hi,
> I am having problem with update command. I run it directy in the mysql console, it works. But when I run it from perl, it does not work.
>
> here is the perl script
>
> my $server2 = 'localhost';
> my $db2 = '<database>';
> my $username2 = '<username>';
> my $password2 = '<password';
>
> my $dbh2 = DBI->connect("dbi:mysql:$db2:$server2", $username2, $password2);
>
> my $query = "UPDATE flightInfo SET route='chicago, atlanta' WHERE passengerIndex='15' AND passengerName='Eko Budiharto';";
my ($sth) = $dbh2->prepare($query);
$sth->execute();
$sth->finish();
> $dbh2->disconnect;
> I do not why the "UPDATE" command does not work with the script. Please help. I thought I used wrong syntax.
>
yes?
uru
-Dave
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/[email protected]