if you have a windows machine for a front end,
download corereader from http://corereader.com/
it's free. it will connect to your mysql server
(and anything else).
it lets you do point and click queries, so you can
very quickly experiment to get the results that you
want. it also builds a sql statement in case you
need it.
it installs in novice mode, so change it to the
proficient level to do the functions.
fair warning: at the proficient level, it can do
complex queries, so pay attention to your logic.
> OK. Maybe I'm expecting too much of myself, but I can't figure out what I am
> doing wrong here:
>
> mysql> select * from example;
> +-------+--------+
> | first | second |
> +-------+--------+
> | 1 | 2 |
> | 2 | 3 |
> +-------+--------+
> 2 rows in set (0.00 sec)
>
> mysql> select first, second, SUM(first) from example group by first;
> +-------+--------+------------+
> | first | second | SUM(first) |
> +-------+--------+------------+
> | 1 | 2 | 1 |
> | 2 | 3 | 2 |
> +-------+--------+------------+
> 2 rows in set (0.00 sec)
>
>
> If it is not obvious, I want the sum of "first," which, by my calculations,
> should be 3. What am I doing wrong?
>
>
> Thanks!
>
> --kevin
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
---------------------------------------------------------------------
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
