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.
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
