Re: [cobalt-users] MySQL

["Thomas Knudstrup" <thomas@xxxxxxxxxxxx>]

Den 24 Nov 99, kl 22:34, skrev Bjarke Alling (BA):

BA> I can get the right values on a RaQ 2, running MySQL 3.22.21

Yes you can, but to be more specific, here is some examples:

mysql> select ROUND(-4.456);
+---------------+
| ROUND(-4.456) |
+---------------+
|            -4 |
+---------------+
1 row in set (0.05 sec)

mysql> select ROUND(-4.656);
+---------------+
| ROUND(-4.656) |
+---------------+
|            -5 |
+---------------+
1 row in set (0.00 sec)

mysql> select PI();
+----------+
| PI()     |
+----------+
| 3.141593 |
+----------+
1 row in set (0.00 sec)

mysql> select SQRT(144);
+-----------+
| SQRT(144) |
+-----------+
| 12.000000 |
+-----------+
1 row in set (0.00 sec)

mysql> select LOG(2);
+----------+
| LOG(2)   |
+----------+
| 0.693147 |
+----------+
1 row in set (0.00 sec)

mysql> select FROM_UNIXTIME(875996580) + 0;
+------------------------------+
| FROM_UNIXTIME(875996580) + 0 |
+------------------------------+
|               19971004222300 |
+------------------------------+
1 row in set (0.02 sec)
 

BA> This is what I did install two months ago.
BA> 
BA> glibc-*-2.0.7-29C2.mips.rpm
BA> kernel-*-2.0.34-C49_SK.mips.rpm
BA> modutils-2.1.121-1_C3.mips.rpm
BA> MySQL-3.22.21-2C1.mips.rpm
BA> MySQL-client-3.22.21-2C1.mips.rpm
BA> MySQL-devel-3.22.21-2C1.mips.rpm

And it works :-)

/thomas