Page 1 of 1

Error When Deleting SQL Row

Posted: Wed Aug 16, 2006 12:23 am
by Supper Baby
Hello

When I try to delete one row from my table I use the following command :

Code: Select all

DELETE FORM `table_name` WHERE id=1
Here I got that Erorr Message :

Code: Select all

Erorr NO. 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 'WHERE id=1' at line 1
What's the correct command ??

Posted: Wed Aug 16, 2006 12:25 am
by RobertGonzalez
Did you even look at this? :wink:
From is spelled F-R-O-M not F-O-R-M

Code: Select all

DELETE FORM `table_name` WHERE id=1
Should be

Code: Select all

DELETE FROM `table_name` WHERE id=1

Posted: Wed Aug 16, 2006 11:58 am
by Supper Baby
Everah wrote:Did you even look at this? :wink:
From is spelled F-R-O-M not F-O-R-M

Code: Select all

DELETE FORM `table_name` WHERE id=1
Should be

Code: Select all

DELETE FROM `table_name` WHERE id=1
Thanks Man :lol: