Hi all,

I have a small problem.
I have to change the default delimiter of MySql from ';' to '$'.

When i give the command "delimiter $" in the MySql  command prompt it
works fine.
But when i do the same thing from my code :

statement.execute("DELIMITER $")

it gives this error,
"java.sql.SQLException: 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 'DELIMITER $' "  Exception.

If any one has any clue... pls tell me where it is going wrong.

thank you,
Sarath