Your statement is saying: if 3 is greater than 2, delete all
Your WHERE criteria should be based upon a specific field's contents, NOT
its position in a data base
-Original Message-
From: Jan Grafström [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 11:51 AM
To: [EMAIL
Hi!
I am new to this an wonder how to delete a row in my table.
I have tryed with:
--
DELETE FROM mytable WHERE 32
-
to delete row number 3 but all rows goes away!
Thanks in advance for any help.
Regards
Jan
That's because the number 3 is greater than the number 2, so is