[cobalt-users] MySQL

["Drew Nichols" <drewnichols@xxxxxxxxxxx>]

I spent a little bit of time trying to figure out
what I was doing wrong with my SQL queries.  Then
I tried simple functions directly out of the MySQL
tutorial found at www.mysql.com.

I should be getting this:

mysql> select SQRT(4);
            -> 2.000000

But I am currently getting this:

mysql> select SQRT(4);
+----------+
| SQRT(4)  |
+----------+
| 0.000000 |
+----------+

I should be getting this:

mysql> select PI();
            -> 3.141593

But i am getting this:

mysql> select PI();
+---------------------------------------------------------------------------
----
----------------------------+
| PI()
                           |
+---------------------------------------------------------------------------
----
----------------------------+
|
861919951281538276623897189472890945116772092561332099642373187003009130824758
55805240843511529472.000000 |
+---------------------------------------------------------------------------
----
----------------------------+

I can't do sum() or avg().  I cant do max() or min()  I can't mathematically
calculate anything. :)  If you could look into it, I would appreciate it.

Thanks,
Drew Nichols

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com