Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF, 078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries

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