csrao ch wrote:
> Hi All,
>
> I am Chandrasekhara Rao, new to this
> group. I have a dought regarding JAVA-MySQL.
>
> I have a file which contains list of
> some MySQL statements. My problem is I am able to
> execute the
> command " source fileName.sql" from
> MySQL prompt. But the same command I could n't
> able to
> execute from JAVA. Why is it so ?
> any idea? Can anybody help me?
The 'source' command is part of the MySQL command-line client, not any other clients, so the answer is "no" it won't work. You will need to read and parse the .sql file yourself.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html