Hi ,
This is a little off topic but I have seen count(*) on this list afew
times and it got me wondering...
Is there a reason to use SELECT COUNT(*) as opposed to SELECT COUNT(column)?
I have noticed that selecting count(*) versus specifying the column
name executes much more slowly.
I've been
ax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'RETURN CONCAT('Hello, ',s,'!');
DELIMITER' at line 2
--
Nic Stevens - [EMAIL PROTECTED]
near '(s CHAR(20)) RETURNS CHAR(50)
RETURN CONCAT('Hello, ',s,'!')' at line 1
DELIMITER ;
//
Can someone elucidate the mystery of either stored functions or UDF's?
Thanks, in advance,
Nic
--
Nic Stevens - [EMAIL PROTECTED]