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