In mysql console we will use the delimiter command to change the delimiter and it is useful to define the procedures.
I understood the command
delimiter for only the mysql client(client side command).
but I am using the mysql client which does not have the command
dbslayer, on this kind of clients how can I define the procedures.
for now consider:
create procedure test_pro() begin select 'hello pro'; end
I tried the following :
mysql -u root -pmypass test < proc_file
where proc_file contains the above procedure;
but that is giving me the following error:
ERROR 1064 (42000) at line 1: 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 '' at line 3
Event I tried the following
create procedure test_pro() begin select 'hello pro'; end;
(added the trailing semicolon) but am getting the same error .
Same I am experiencing with the
dbslayer , if I am able to define the above procedure through terminal I think I should be able to do that through the