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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]