Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download

Links

XODOX
Impressum

#1: Re: WHERE mit AND

Posted on 2008-03-30 00:56:45 by hellbringer

Martin Pöpping schrieb:
> hellbringer schrieb:
>
>>> DELETE FROM 'logs' WHERE (id > '368') AND (id < '1102');
>>
>> DELETE FROM `logs` WHERE id > 368 AND id < 1102;
>
> Nein, geht auch nicht:
>
> Fehler
>
> SQL-Befehl:
>
> DELETE FROM 'logs' WHERE id >368 AND id <1102
>
> MySQL meldet: Dokumentation
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near ''logs' WHERE id >368 AND id <1102' at line 1
>
>
> Es handelt sich um die MySQL Server Version: 4.1.22
>
> Hat noch jemand irgendwelche anderen Ideen?

ja,

DELETE FROM `logs` WHERE id > 368 AND id < 1102;

Bitte diesmal richtig abtippen, dann funktioniert es auch.

Report this message