count(*)? was: Re: Query Question...

2005-07-16 Thread Nic Stevens
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

Stored function problems (Was: UDF failure)

2005-07-07 Thread Nic Stevens
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]

UDF failure

2005-07-06 Thread Nic Stevens
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]