Is passengerIndex a numeric or varchar type? If
numeric, the problem could be the quotes around '15'.
--- Eko Budiharto <ebud...@yahoo.com> 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';";
$dbh2->disconnect;
I do not why the "UPDATE" command does not work with
the script. Please help. I thought I used wrong
syntax.
4 messages in com.mysql.lists.perlRe: update command
