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
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()|
+--+
|
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
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 to
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; check the manual