Re: update command
Robin Hughes <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Is passengerIndex a numeric or varchar type? If numeric, the problem could be the quotes around '15'. --- Eko Budiharto <[email protected]> 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. > > > > --------------------------------- > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]