unable to change delimiter[solved]

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

unable to change delimiter[solved]

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 ...

Code: Select all

mysql> delimiter //
    ->
Last edited by raghavan20 on Wed Apr 12, 2006 4:37 am, edited 1 time in total.
User avatar
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).
User avatar
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 ;
User avatar
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...
Post Reply