Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Wwwxxx.comvam, WWWXXX AMS, WWWXXX.APC, should producers of software based systems services such as atms be held liable for economic injuries suffered when their systems failed, WWWXXX DOCO, WWWXXX BDCE, WWWXXX DACB, wwwxxx,nvif, why atm producer might be held liable for economic injury, wwwxxxy=ServiceLogin

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