Setting delimiter

------=_NextPart_000_006F_01C58D3C.FF4CE1F0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hey,

Does anyone know why Im having suck trouble setting the
delimiter value?

I am running MySQL 5.0.8 and when I try and set it nothing happens. This is
what im doing.



Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2 to server version: 5.0.9-beta-nt



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql> delimiter $

->

->



If you have any idea how to fix this please let me know

Thanks

Enda


------=_NextPart_000_006F_01C58D3C.FF4CE1F0--

Re: Setting delimiter

IMHO its dangerous and useless to change the default delimiter,
causing portability and compatibility problems, but if you want it,
well, you do it... Try:

delimiter $;

This way you end your command and MySQL execute it (because the
default delimiter is there, ;) and after this command, the new
delimiter will take effect, try this (with the default delimiter still
;):

delimiter $; show databases$ status$

Will change the default delimiter, that will take effect right after
the command is executed, and then your queries will take effect
because the new delimiter is $.

On 7/20/05, Enda Dowling wrote:
> Hey,
>=20
> Does anyone know why Im having suck trouble setting the
> delimiter value?
>=20
> I am running MySQL 5.0.8 and when I try and set it nothing happens. This =
is
> what im doing.
>=20
>=20
>=20
> Welcome to the MySQL monitor. Commands end with ; or \g.
>=20
> Your MySQL connection id is 2 to server version: 5.0.9-beta-nt
>=20
>=20
>=20
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>=20
>=20
>=20
> mysql> delimiter $
>=20
> ->
>=20
> ->
>=20
>=20
>=20
> If you have any idea how to fix this please let me know
>=20
> Thanks
>=20
> Enda
>=20
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Setting delimiter

"IMHO its dangerous and useless"

What if you want to create stored procedures? Hint: They might contain
statements that end in the standard delimiter...

-----Original Message-----
From: danieldaveiga@gmail.com [mailto:danieldaveiga@gmail.com]
Sent: 20 July 2005 15:52
To: win32@lists.mysql.com
Subject: Re: Setting delimiter

IMHO its dangerous and useless to change the default delimiter, causing
portability and compatibility problems, but if you want it, well, you do
it... Try:

delimiter $;

This way you end your command and MySQL execute it (because the default
delimiter is there, ;) and after this command, the new delimiter will take
effect, try this (with the default delimiter still
;):

delimiter $; show databases$ status$

Will change the default delimiter, that will take effect right after the
command is executed, and then your queries will take effect because the
new delimiter is $.

On 7/20/05, Enda Dowling wrote:
> Hey,
>
> Does anyone know why Im having suck trouble setting the
> delimiter value?
>
> I am running MySQL 5.0.8 and when I try and set it nothing happens.
> This is what im doing.
>
>
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
>
> Your MySQL connection id is 2 to server version: 5.0.9-beta-nt
>
>
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>
>
> mysql> delimiter $
>
> ->
>
> ->
>
>
>
> If you have any idea how to fix this please let me know
>
> Thanks
>
> Enda
>
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=tim.lloyd@biomni.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Setting delimiter

My need for changing the delimiter is to write store procedures so its
necessary.
I found out what I was doing wrong and I got it sorted thought,
Thanks

-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
Sent: 20 July 2005 19:52
To: MySQL Win32 List
Subject: Re: Setting delimiter

IMHO its dangerous and useless to change the default delimiter,
causing portability and compatibility problems, but if you want it,
well, you do it... Try:

delimiter $;

This way you end your command and MySQL execute it (because the
default delimiter is there, ;) and after this command, the new
delimiter will take effect, try this (with the default delimiter still
;):

delimiter $; show databases$ status$

Will change the default delimiter, that will take effect right after
the command is executed, and then your queries will take effect
because the new delimiter is $.

On 7/20/05, Enda Dowling wrote:
> Hey,
>
> Does anyone know why Im having suck trouble setting the
> delimiter value?
>
> I am running MySQL 5.0.8 and when I try and set it nothing happens. This
is
> what im doing.
>
>
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
>
> Your MySQL connection id is 2 to server version: 5.0.9-beta-nt
>
>
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>
>
> mysql> delimiter $
>
> ->
>
> ->
>
>
>
> If you have any idea how to fix this please let me know
>
> Thanks
>
> Enda
>
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=enda.dowling@sentenial.ie





--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org