RE: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread Gelu Gogancea
mysql.com Subject: Re: Split a Delimited String in SQL ( PROCEDURE split_string ) On Wednesday 21 June 2006 13:37, listsql listsql wrote: > Just for the happy comment: Argentina Will win the match tonight against > Holland :) > MARTIN ERROR 1064 (42000): You have an error in your SQL syntax

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread Jørn Dahl-Stamnes
On Wednesday 21 June 2006 13:37, listsql listsql wrote: > Just for the happy comment: Argentina Will win the match tonight against > Holland :) > MARTIN ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t

RE: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread Logan, David (SST - Adelaide)
Hi, There are a couple of errors in the way it is defined, firstly 1) There should be a ; after the DROP PROCEDURE statement 2) use a delimiter //, this stops the mysql client trying to interpret the other ; as the end of the command. It then takes everything until the next // as belonging to th

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread listsql listsql
Definitivaly stopping and going for one or two cups of coffee. I was logged in to another mysql... when I copied the last email. Sorry guys, I don't want to add extra non-sense text to the list! +--+ | version()| +--+ | 5.

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread listsql listsql
Sorry forgot to copy my version: It's not acepting the delimiter command, can be ? I'm really missing something here. +---+ | version() | +---+ | 4.0.24_Debian-10ubuntu2.3-log | +---+ mysql> de