Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Mysql, come si fa una somma di campi?

2 views
Skip to first unread message

Led

unread,
Jun 27, 2009, 3:54:31 AM6/27/09
to
Come si fa a sommare due campi non presenti nel record ma creati dalla
query con la keyword "AS"?

SELECT 1 AS aaa, 2 AS bbb, (aaa + bbb) AS ccc

Non funziona perchￜ non trova i campi aaa e bbb nel record.

Per intenderci invece:

SELECT 1 AS aaa, 2 AS bbb, (1 + 2) AS ccc

Funziona.

Grazie.

rootkit

unread,
Jun 27, 2009, 4:42:44 AM6/27/09
to

select (aaa + bbb) as ccc
from
(select 1 as aaa, 2 as bbb
from stocazzditabella)

--
++ questo messaggio ￜ scritto in forma ridotta per venire incontro alle
vostre capacitￜ mentali
http://www.elogiclab.net/blog/
http://www.flickr.com/photos/marko_po/

Led

unread,
Jun 27, 2009, 5:47:33 AM6/27/09
to
rootkit ha scritto:

> select (aaa + bbb) as ccc
> from
> (select 1 as aaa, 2 as bbb
> from stocazzditabella)

Grazie.

0 new messages