Thomas,
As you've discovered, MySQL documentation doesn't (yet) include a syntax
diagram, but there's a manual page for WHERE clauses, there's a manual
page for logical operators including XOR, and they show that the answer
to your question about WHERE clauses using XOR is 'yes', as does writing
the simplest possible toy query on a test table. MySQL is open source.
Perhaps you'll be the one to write the syntax diagram?
PB
-----
Thomas Sundberg wrote:
>>-----Original Message-----
>>From: Michael Stassen [mailto:Michael.Stassen@stripped]
>>Sent: den 4 februari 2005 14:19
>>To: Thomas Sundberg
>>Cc: mysql@stripped
>>Subject: Re: Syntax diagram, where is it located in the doc?
>>
>> From the manual, "where_definition consists of the keyword
>>WHERE followed by an expression that indicates the condition
>>or conditions that rows must satisfy to be selected."
>><http://dev.mysql.com/doc/mysql/en/select.html>
>>
>>That seems simple and straightforward to me. Perhaps if you
>>told us why you need this, someone could provide you with the
>>answer you need.
>>
>>
>
>It is very simple but absolutely not straight forward. It really doesn't say
>anything. Just that you should do things right and then you will not have
>any problems.
>The concrete problem I tried to solve were if MySQL supports xor in a where
>clause. And if so, how should the syntax be written? That would have been
>extremely simple if the syntax diagram started just above the quote you
>supplied us with had been completed and not ended when things got a bit
>interesting.
>
>/Thomas
>
>
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005
| Thread |
|---|
| • Syntax diagram, where is it located in the doc? | Thomas Sundberg | 2 Feb |
| • Syntax diagram, where is it located in the doc? | Thomas Sundberg | 4 Feb |
| • Re: Syntax diagram, where is it located in the doc? | Alec.Cawley | 4 Feb |
| • Re: Syntax diagram, where is it located in the doc? | Jeremy Cole | 4 Feb |
| • RE: Syntax diagram, where is it located in the doc? | Thomas Sundberg | 7 Feb |
| • Re: Syntax diagram, where is it located in the doc? | Gleb Paharenko | 4 Feb |
| • RE: Syntax diagram, where is it located in the doc? | Thomas Sundberg | 4 Feb |
| • Re: Syntax diagram, where is it located in the doc? | Michael Stassen | 4 Feb |
| • RE: Syntax diagram, where is it located in the doc? | Thomas Sundberg | 4 Feb |
| • RE: Syntax diagram, where is it located in the doc? | Alec.Cawley | 4 Feb |
| • Re: Syntax diagram, where is it located in the doc? | Peter Brawley | 4 Feb |
| • RE: Syntax diagram, where is it located in the doc? | Alec.Cawley | 4 Feb |
| • RE: Syntax diagram, where is it located in the doc? | Tom Crimmins | 4 Feb |