That should work.
What OS, kernel, version, compiler are you using?
kitty79 wrote:
> hi folks,
> i have the following table (table_name=comment)
> +---------+----------------------+------+-----+------------+----------------
> +
> | Field | Type | Null | Key | Default | Extra
> |
> +---------+----------------------+------+-----+------------+----------------
> +
> | id | smallint(5) unsigned | | PRI | 0 | auto_increment
> |
> | taste | int(6) | | | 0 |
> |
> | ph | int(6) | | | 0 |
> |
> | enabled | char(1) | YES | | N |
> |
> +---------+----------------------+------+-----+------------+----------------
> +
>
> with the following content:
> +----+-------+----+---------+
> | id | taste | ph | enabled |
> +----+-------+----+---------+
> | 1 | 5 | 8 | |
> | 2 | 2 | 7 | |
> | 3 | 8 | 3 | |
> +----+-------+----+---------+
>
> and want to do a select statement like
> select SUM(taste) FROM comment;
> to get the summation of taste (here 15)
>
> mysql> select SUM(taste) FROM comment;
> +------------+
> | SUM(taste) |
> +------------+
> | 0 |
> +------------+
> and got this result:-( whats wrong? thank you:-)
>
> Tobias
>
>
> ---------------------------------------------------------------------
> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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