how about something like this, which finds one row (if any) with the
lowest in-stock price, UNIONs it with the highest out-of-stock price (if
any), and then returns just one row, including whether that was an
in-stock or out-of-stock price:
(SELECT col1, price, quantityOnHand, 1 as inStock
FR
On Thu, 11 Jan 2001, Tõnu Samuel wrote:
> We still try to answer questions and value your time. Just some
> questions are repeating up to 3 times per day, other people do not
> provide any data with their questions and finally all MySQL
> development goes slower because this. We are providing fre
From: "Neil Davis" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 6:58 PM
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decided to teach
myself
> BASIC. All I had was the manual. (the MySQL manual is the library of
> If it is documented somewhere, and can be produced
uarantee you'll several different versions.
- Original Message -
From: "Neil Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 1:58
Subject: Re: Lazy
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decide
admin that sometimes I transgress out of panic and usually quickly get
> corrected, but I don't cry about it; I remember where I am, why I am here,
> and solve the problem with the available information. I still haven't been
> beat by a problem.
>
> L8,
> Neil
&g
]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 11:17 AM
Subject: Re: Lazy
> Interesting. My guess is that you must be in your early 20s. When I was
at
> high school (& even uni), apart from normal lessons, researching for
> assignments, etc, meant going to the li
nly be there as a guide
> but would never give us the answer. I guess the quality of teaching and
> graduates have dropped greatly since I left high school.
>
> Cheers
>
>
> - Original Message -
> From: "John Cichy" <[EMAIL PROTECTED]>
> T
ED]>
To: "Don" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 0:47
Subject: Re: Lazy
> Human nature and education...
>
> In most cases as youngsters we are 'given' the answers and the methods for
> solving our problems. As we get ol
Human nature and education...
In most cases as youngsters we are 'given' the answers and the methods for
solving our problems. As we get older we continue to expect this and un-able
to function when told to figure something out.
My first computer class in High school (NCR Mainframe/BASIC), I h
t;
> > -Original Message-
> > From: Eric Fitzgerald [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, January 11, 2001 12:29 PM
> > To: Carlos Corzo; [EMAIL PROTECTED]
> > Subject: Re: Lazy
> >
> > Some people have looked at the manual's, ye
> Carlos Corzo wrote:
>
> > Some people have tried the manuals verbatim but are really confused
> > because they are not at your intellectual level. If this list is for
> > the "intelligent only", change the title please. Not everyone can
> > decipher a manual. I may post questions but there ar
Hi,
May I offer a bit of distraction and an idea?
Below might draw flames of (browse the site), but I like databases because
they turn me on
I am a recovering micsofrot addict. WHEW! It feels good to get that off my
chest. I am also a Linux newbie (Since 12-00) and am exploring MySQL. I hav
Quentin Bennett writes:
> Perhaps, along with the 'Please check the manual' message at the end of all
> messages, there should be a reference to a reliable archive, allowing list
> users who are referred to the archive an easy way of finding it!
Done.
--
__ ___ ___ __
/ |/ /_
ald [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 11, 2001 12:29 PM
> To: Carlos Corzo; [EMAIL PROTECTED]
> Subject: Re: Lazy
>
> Some people have looked at the manual's, yes, and it's pretty simple to
> determine when they have. If the question they ask can b
> I didn't wanted to make you upset. We still try to answer questions and
> value your time. Just some questions are repeating up to 3 times per
That's great coming from a great team.
Who knows ? There might be people who are tasked to frustrate you and this
group.
For the benefit of the open-sour
Aaron Schlesinger wrote:
> I agree with Carlos's response below. Tõnu I appologize for singling you
> out, but if you push away those simple questions, you'll just force those
> who are just getting started to find more patient people and software to
> use.
Critics is good :). I try to be more p
Agreed!
Eric Fitzgerald wrote:
> Some people have looked at the manual's, yes, and it's pretty simple to
> determine when they have. If the question they ask can be copied/pasted
> into the mysql documention search and get the answer, then the person has
> not checked the documentation. Someti
e just getting started to find more patient people and software to
use.
Aaron
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tõnu Samuel
Sent: Wednesday, January 10, 2001 6:44 PM
To: Carlos Corzo
Cc: [EMAIL PROTECTED]
Subject: Re: Lazy
Carlos Corzo wr
At 05:58 PM 1/10/01, Carlos Corzo wrote:
>Some people have tried the manuals verbatim but are really confused
>because they are not at your intellectual level. If this list is for
>the "intelligent only", change the title please. Not everyone can
>decipher a manual. I may post questions but the
Carlos Corzo wrote:
> Some people have tried the manuals verbatim but are really confused
> because they are not at your intellectual level. If this list is for
> the "intelligent only", change the title please. Not everyone can
> decipher a manual. I may post questions but there are reasons
Some people have looked at the manual's, yes, and it's pretty simple to
determine when they have. If the question they ask can be copied/pasted
into the mysql documention search and get the answer, then the person has
not checked the documentation. Sometimes people miss things in the
documentati
21 matches
Mail list logo
