update command

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!