On 30/03/2011 09:05, Brent Clark wrote:
Hiya
Im wondering if someone could help me understand this. If you look at my
two queries below. By the ORDER BY one is using ` and the other ', as a
result, if you do an explain you will see that the top query does a
filesort, while the other does not.
On Wed, 30 Mar 2011 10:05:50 +0200
Brent Clark wrote:
> Hiya
>
> Im wondering if someone could help me understand this. If you look at my
> two queries below. By the ORDER BY one is using ` and the other ', as a
> result, if you do an explain you will see that the top query does a
> filesort,
Yes - it works in MySQL, as does ||. See:
http://dev.mysql.com/doc/refman/5.1/en/logical-operators.html#operator_and
On Mon, Mar 2, 2009 at 5:02 PM, John Daisley <
john.dais...@mypostoffice.co.uk> wrote:
> Never seen && used with MySQL, does it really work???
>
> As for other RDBMS, I reckon
Never seen && used with MySQL, does it really work???
As for other RDBMS, I reckon its likely to cause problems in Oracle as
&& is used for session substitution variables in SQL*Plus.
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: 07812 451238
MySQL Certified Database Administr
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
conditionals.
Martin
__
Disclaimer and confident
On Mon, Dec 22, 2003 at 04:43:07PM +0200, Warren Burstein wrote:
>
> I am running mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) on
> RedHat 6.2 (so shoot me, I'm using an old scratch computer so I
> won't break anything on the real development machine)
>
> I tried to create a user by inserti
* Warren Burstein <[EMAIL PROTECTED]> [2003-12-22 15:43 +0100]:
> I tried to create a user by inserting directly into mysql.user. When
> I set user.host to localhost, it works, when I set it to % it doesn't.
> I thought % matched anything, and so should match localhost.
mysqld will ignore rows wi
