| Subject: | problems with mysql queries |
| Date: | Wed, 11 Mar 2009 13:25:25 +0000 |
| To: | <bug-sql-statement [...] rt.cpan.org> |
| From: | Toni Casueps <casueps [...] hotmail.com> |
I'm trying to parse a query and I get this error:
SQL ERROR: Junk after table name 'N30_naps_future'
This is the code that I used:
$parser = SQL::Parser->new();
my $success = $parser->parse("update N30_naps_future n, nenaptype t set match_port_userlabel = concat(n.actual_eqpt_name,'/',replace(replace(t.userlabeltype,'SLOTNUMBER',concat('%',n.card)),'PORTNUMBER',concat('%',n.port)) ) where n.actual_eqpt_netype = t.netypeid");
my %output = %{$parser->structure};
The sentence is correct because I can execute it with a MySQL client. Is this a bug in the parser?
Show quoted text
_________________________________________________________________
Llévate Messenger en el móvil a todas partes ¡Conéctate!
http://www.microsoft.com/spain/windowsmobile/messenger/default.mspx