MySQL server version for the right syntax to use
near 'CREATE PROCEDURE split_string (
IN input TEXT,
IN delimiter VARCHAR(10' at line 2
Just for the happy comment: Argentina Will win the match tonight against
Holland :)
MARTIN
On 6/21/06, listsql listsql <[EMAIL PROTECTE
;delimiter //
CREATE PROCEDURE simpleproc (OUT param1 INT)
BEGIN
On 6/21/06, listsql listsql <[EMAIL PROTECTED]> wrote:
Hi all,
I was trying this:
http://forge.mysql.com/snippets/view.php?id=4
That is supposed to emulate a split() in mysql.
Could anyone make it work ?
I'v
Hi all,
I was trying this:
http://forge.mysql.com/snippets/view.php?id=4
That is supposed to emulate a split() in mysql.
Could anyone make it work ?
I've been trying without luck. I 'm getting strange errors when trying to
create this procedure.
_
DROP P
>i'm not sure who the original poster was
I'm Fasani, I work in a spanish telecommunications company on the
statistics department as a DBA/developer. I'm on this list because we
use mysql for the online statistics and I'm always reading this when I
have some free time.
Thanks all who commented on
Since I read about Foaf [ http://www.foaf-project.org/ ], I become
interested with Social Networking, and readed a lot about it.
I 've been playing as well with mysql and join querys to represent
network's of people. As I made some queries in google and didn't came
with a lot interesting info about
UNIX_TIMESTAMP('1997-12-30 01:01:01.02') -
> UNIX_TIMESTAMP('1997-12-31 23:59:59.01')) as `diff in hh:mm:ss`
>
> date 1 in seconds: 883465261
> date 2 in seconds: 883634399
> diff in seconds: -169138
> diff in hh:mm:ss: -46:58:58
>
> So
TIMEDIFF(expr,expr2)
TIMEDIFF() returns the time between the start time expr and the
end time expr2. expr and expr2 are time or date-and-time expressions,
but both must be of the same type.
mysql> SELECT TIMEDIFF('1997-12-31 23:59:59.01',
-> '1997-12-30 01:01:01.02'
