Hi.
On Thu, Apr 19, 2001 at 05:41:54PM +0200, [EMAIL PROTECTED] wrote:
> Hallo Leute,
>
> in Oracle kann man Indizes in einer Abfrage abschalten(Full-Table-Scan). Mit +0 oder
>||''.
> z.B.:
>
> SELECT *
> FROM tabelle
> WHERE eigenschaft||'' = 'text';
>
> SELECT *
> FROM tabelle
> WHERE id+0
Es gibt eine deutsche MySQL-Sendenliste:
There is a German MySQL mailing list:
[EMAIL PROTECTED]
"subscribe mysql-de [EMAIL PROTECTED]"
-Philip Mak ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/m
I'll try to translate:
in oracle one can turn off indexes within a query (full-table-scan) by
using: +0 or ||''.
for example:
SELECT *
FROM tabelle
WHERE eigenschaft||'' = 'text';
SELECT *
FROM tabelle
WHERE id+0 = 1;
can one do this with mysql?
- Original Message -
From: "Hagen Schmied
