Re: DIV-function?

2005-08-31 Thread Joachim Klöfers
-- -- Data Request Services Joachim Klöfers Dekan-Schuster-Str. 17 D-63110 Rodgau Tel.:(+49)(0)6106-21448 email: [EMAIL PROTECTED] -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: DIV-function?

2005-08-31 Thread Joachim Klöfers
for the DIV-function. But it is there |DIV| Integer division. Similar to |FLOOR()| but safe with |BIGINT| values. mysql *|SELECT 5 DIV 2;|* - 2 |DIV| is new in MySQL 4.1.0. Joachim -- -- Data Request Services Joachim Klöfers Dekan-Schuster-Str. 17 D

Query problem

2005-02-08 Thread Joachim Klöfers
Hi, all I hope somebody can help me. Situation Three tables 1. ++++ | id | name | region | ++++ | 13 | Name1 | 1 | | 15 | Name2 | 2 | | 47 | Name3 | 1 | | 57 | Name4 | 2 | | 65 | Name5 | 2 | |

Query question

2005-02-01 Thread Joachim Klöfers
Hi, all I hope somebody can help me. Situation Three tables 1. ++++ | id | name | region | ++++ | 13 | Name1 | 1 | | 15 | Name2 | 2 | | 47 | Name3 | 1 | | 57 | Name4 | 2 | | 65 | Name5 | 2 | |

Mysql installation problem on NT

2001-11-22 Thread Joachim Klöfers
Hi, all, I tried to install mySQL on Windows NT (Service Pack 6). That means: Unzipping, installing, then starting mySQL as a service with : mysqld-nt --install. Until now everything worked fine and we saw the service in the NT's Service list. But we could not start the service. Neither with