MySQL Forums
Forum List  »  Perl

to do mysql source command from perl
Posted by: Rytis Diciunas
Date: November 15, 2006 07:22AM

hi, i want what perl asks mysql to that :

$sth = $dbh->prepare ("source /home/user/ids.sql;");
$sth->execute;

where ids.sql includes other source and load commands....

mysql gives me error:
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'source ids.sql'

any ideas, what i am doing wrong...

Options: ReplyQuote


Subject
Written By
Posted
to do mysql source command from perl
November 15, 2006 07:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.