batch sql SOURCE command

How can I execute the SOURCE command? When I try I get a syntax error
(from DBI, works on the commandline).

http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

I could just use a do() loop, but I think this would be better

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules [at] m .gmane.org
R P [ Mi, 02 Mai 2007 23:08 ] [ ID #1702698 ]

Re: batch sql SOURCE command

At 4:08 PM -0500 5/2/07, R P wrote:
>How can I execute the SOURCE command? When I try I get a syntax error
>(from DBI, works on the commandline).
>
>http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html
>
>I could just use a do() loop, but I think this would be better

It's a command implemented by the mysql client program, it's not a
SQL statement. You'll need to implement it yourself.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules [at] m .gmane.org
Paul DuBois [ Mi, 02 Mai 2007 23:22 ] [ ID #1702699 ]
Datenbanken » gmane.comp.db.mysql.perl » batch sql SOURCE command

Vorheriges Thema: Leak with prepared statements and mysql_server_prepare=1
Nächstes Thema: Installing DBD::mysql with cygwin