Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
-
Contact:
Post
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 ...
Last edited by
raghavan20 on Wed Apr 12, 2006 4:37 am, edited 1 time in total.
-
feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Post
by feyd »
I don't see that in the reserved word list(s).
-
raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
-
Contact:
Post
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 ;
-
raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
-
Contact:
Post
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...