471,075 Members | 815 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

spaces in MySQL functions

Did you know...

Using SUM as an example, seems true with all functions:
SUM (...) doesn't work, but SUM(...) does (note the space between the
function and the argument list)? I just spent painful minutes banging
my head over this one.

Is this strange, or am I just the last one to know about it?

FWIW, I'm running 4.1.9-nt
Jul 23 '05 #1
1 1135
"hoonew" <ho****@ino.now> wrote in message
news:VhWAe.103450$gc6.72029@okepread04...
Did you know...

Using SUM as an example, seems true with all functions:
SUM (...) doesn't work, but SUM(...) does (note the space between the
function and the argument list)? I just spent painful minutes banging
my head over this one.

Is this strange, or am I just the last one to know about it?

FWIW, I'm running 4.1.9-nt


I don't think it's strange.

In fact, it surprised me that any common language *permits* a space between
a function and it's argument list. I just never see it done that way and
MySQL obviously doesn't like it. Surprisingly, my C compiler and Python
interperter permit it! But I had to try it because, never having put that
kind of space in my code, I never noticed.

However, now that I know -

I think I'll continue to fall back on the fact that -
the *absence* of whitespace between a function and it's arguments seems to
make everything happy :-)
Thomas Bartkus
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ragnorack67 | last post: by
reply views Thread by Philip Stoev | last post: by
reply views Thread by Mike Chirico | last post: by
3 posts views Thread by slash | last post: by
5 posts views Thread by Marco Gallo | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.