Hi,
On Mon, Mar 31, 2003 at 03:40:03PM +0100, warm-fusion wrote:
> Hi, I'm just wondering what the right syntax for using the delete
> statement is? I'm trying to write a simple garbage collection/deletion
> query similar to the queries below.
>
> delete from 'item' where 'quantity_of_item_in_stock' <= 10;
>
Why do you use quotes around table and field names? If you want to, then
use backquotes (`) i.s.o. quotes (') or double quotes ("). The latter
are used for strings.
> (the above version of the query pops up a Java-applet alert asking if I
> really want to xyz, then it gives an error in MyPHPAdmin)
>
> delete * from 'item' where 'quantity_of_item_in_stock' <= 10;
>
Yes, this is incorrect syntax.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
