Page 1 of 1
unable to change delimiter[solved]
Posted: Tue Apr 11, 2006 2:56 pm
by raghavan20
I am trying to change the delimiter so that I can write multiple lines in procedures...but I am unable to change the delimiter ...
Posted: Tue Apr 11, 2006 3:30 pm
by feyd
I don't see that in the reserved word list(s).
Posted: Wed Apr 12, 2006 2:28 am
by raghavan20
taken from a mysql .pdf document provided by mysql
Code: Select all
mysql> delimiter //
mysql> create function broker_name (id in
-> returns varchar(50)
-> deterministic
-> begin
-> declare broker_name var_fi
-> select concat(broker broker_name
-> into
-> from broker
-> where broker_id = id;
-> return broker_name;
-> end
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
Posted: Wed Apr 12, 2006 4:37 am
by raghavan20
problem has been solved...it was not working with one of the Db tool, navicat...it works with query browser and mysql client as well...