Re: + x * 31536000

Article View: dk.edb.database

Article #15207

#15207

From: Thomas Lundstrøm
Date: Mon, 09 Jul 2001 19:04

44 lines
1993 bytes


Henrik Hansen wrote:
> 
>  > Jeg vil med een SQL querry finde alle felter som opfylder
>  > 'felt = tal1 + x * tal2' hvor X tilh�rer {..., -3, -2, -1, 0, 1, 2, 3,
>  > ...}
> 
> select felt from table where x in(1,2,3,4,5,6) and felt = tal1 + x * tal2
> 

mysql> SELECT felt FROM test WHERE x in(1,2,3) AND felt = 1+x*1;
Empty set (0.00 sec)

Dette giver efter min mening ikke nogle mening! 
Burde det ikke give 2,3 og 4 n�r:

mysql> SELECT felt FROM test;
+------+
| felt |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
|    5 |
|    5 |
|    6 |
|    7 |
+------+
8 rows in set (0.05 sec)

eller er jeg helt galt p� den?

Bruger MySQL 3.23.33


Thomas L.


-- 
                                        He + St -> HeSt
 Dette burde give en Nobelpris:           2HeSt -> F�l
                                       Ad + F�l -> FAd�l

Technical Details

Message-ID: <3B4A0030.18DA3295@mail.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail

References: <3B487A6C.112CCF35@mail.com> <9ia385$gi7$1@sunsite.dk> <3B49873B.DE1DC0F5@mail.com> <uwv5ifkci.fsf@mailserver.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,c4586e5e5189cd3b
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-09 12:05:51 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail
From: Thomas Lundstrøm <thomas-l@mail.com>
Newsgroups: dk.edb.database
Subject: Re: + x * 31536000
Date: Mon, 09 Jul 2001 21:04:16 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 45
Message-ID: <3B4A0030.18DA3295@mail.com>
References: <3B487A6C.112CCF35@mail.com> <9ia385$gi7$1@sunsite.dk>
  <3B49873B.DE1DC0F5@mail.com> <uwv5ifkci.fsf@mailserver.dk>
NNTP-Posting-Host: 34.ppp1-21.worldonline.dk
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: sunsite.dk 994705545 8873 213.237.2.34 (9 Jul 2001 19:05:45 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Mon, 9 Jul 2001 19:05:45 +0000 (UTC)
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
X-Authenticated: <anon>@<dk>

Reply to Parent Message