On 3/19/2014 7:27 PM, Mogens Melander wrote:
G'morning
A function in a where equals what ?
On Wed, March 19, 2014 15:05, Morgan Tocker wrote:
Hi Christophe,
Considering the following simple query :
SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN
('PENDING', 'ACCEPTED'
G'morning
A function in a where equals what ?
On Wed, March 19, 2014 15:05, Morgan Tocker wrote:
> Hi Christophe,
>
>> Considering the following simple query :
>>
>> SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN
>> ('PENDING', 'ACCEPTED') AND SubscribeDate < DATE_SUB(NOW(),
Am 19.03.2014 16:27, schrieb Morgan Tocker:
> Reindl,
you can call me Harald
>>> The order of the WHERE clause does not matter
>>
>> that is simply not true
>>
>> otherwise that documentation would not exist
>> http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html
>
> Yes, the ord
Reindl,
>> The order of the WHERE clause does not matter
>
> that is simply not true
>
> otherwise that documentation would not exist
> http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html
Yes, the order of the columns in composite indexes *does matter*. This is a
different que
Am 19.03.2014 15:05, schrieb Morgan Tocker:
> When a MySQL server receives a query, it goes through a process called query
> optimization
> and tries to determine the best way to execute it (based on availability of
> indexes etc)
>
> The order of the WHERE clause does not matter
that is simpl
Hi Christophe,
> Considering the following simple query :
>
> SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN
> ('PENDING', 'ACCEPTED') AND SubscribeDate < DATE_SUB(NOW(), INTERVAL 24
> HOUR);
>
> Which of these filters are processed first ?
>
> I'd like the first filter (D
rkbench Pro for MySQL"
using discount coupon MYSQLSPECIAL - additional modules can be
purchased at a later stage.
For more information, see http://www.upscene.com/go/?go=news&id=20140319
The FREE Lite Editions will be released at a later stage.
Database Workbench supports:
- Borlan
> From: Christophe
> To: mysql@lists.mysql.com
> Cc:
> Sent: Tuesday, 18 March 2014, 19:10
> Subject: Precedence in WHERE clauses.
>
> Hi list,
>
> I'd like to get your advice about precedence in where clauses in MySQL
> (5.0.51, and 5.1.66 in this case / from lenny and squeeze Debian
> packa