I haven't checked the manual yet, but I'd guess that the 'query' abilities of
versions "3.22.32" and "3.23.33" are slightly different....
It's generally not a good idea to have different versions (or different 'revs') of
the program on the 'development' and 'production' systems... (you'll have a tough
time figuring out why the production system isn't working the same, and you might
'develop' features that won't run on the production systems)...
Genial Brain Machine wrote:
> Hi,
> I work on the big web site of the gouvernative statistical agency of
> Italy (www.istat.it).
> Recently, I have built a db to collect data from the web (it's like a
> census simulation...) with mySQL.
> Making my querys,I had a little difficult, not so big for me, but that
> can interest you.
>
> On a developpement machine (winNT, apache, mysql 3.23.33) I wrote this
> query:
> "SELECT (fra_g+fra_p+sor_g+sor_p), count(*) FROM alunniE GROUP BY
> (fra_g+fra_p+sor_g+sor_p)",
> where fra_g, fra_p, sor_p, sor_g are, obviously, columns. That works
> right.
>
> When I tried to run the same query on the site machine (Unix Aix,
> apache, mysql 3.22.32, see
> http://www.istat.it:8080/index.php) i discovered that the use of the
> formula in the GROUP BY clause cannot work (any formula).
> The situation on the unix machine seems to be in contrast with the
> manual:
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
>
> where it talks about the possibility to write a formula.
>
> Did you know it?
>
> Greetings
> Sergio Vaccaro
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
