From: Martin Gainty
Date: March 2 2009 9:42pm
Subject: RE: && vs AND
List-Archive: http://lists.mysql.com/mysql/216546
Message-Id: <BLU142-W383F9C55D93570B8475F3DAEA90@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_a5a897d7-3f28-491e-a9fd-5e611f07cf8c_"

--_a5a897d7-3f28-491e-a9fd-5e611f07cf8c_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


there is no && character matrix supported in the SQL92 spec located at

http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

also there is no Truth Table for && but there IS a truth table for AND cond=
itionals.

Martin=20
______________________________________________=20
Disclaimer and confidentiality note=20
Everything in this e-mail and any attachments relates to the official busin=
ess of Sender. This transmission is of a confidential nature and Sender doe=
s not endorse distribution to any party other than intended recipient. Send=
er does not necessarily endorse content contained within this transmission.=
=20




> Subject: && vs AND
> From: daevid@stripped
> To: mysql@stripped
> Date: Mon=2C 2 Mar 2009 13:04:32 -0800
>=20
> Someone sent me a huge SQL query today that used "&&" instead of "AND"
> all over the place. I was a bit surprised that it is legal mySQL=2C but I
> was always under the impression that is not proper. Can anyone confirm
> or deny this? Like will ALL SQL RDBMS support that syntax?
>=20
> http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html

_________________________________________________________________
Windows Live=99 Contacts: Organize your contact list.=20
http://windowslive.com/connect/post/marcusatmicrosoft.spaces.live.com-Blog-=
cns!503D1D86EBB2B53C!2285.entry?ocid=3DTXT_TAGLM_WL_UGC_Contacts_032009=

--_a5a897d7-3f28-491e-a9fd-5e611f07cf8c_--