Error When Deleting SQL Row

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Supper Baby
Forum Commoner
Posts: 27
Joined: Tue Aug 01, 2006 11:33 pm

Error When Deleting SQL Row

Post 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 ??
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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
Supper Baby
Forum Commoner
Posts: 27
Joined: Tue Aug 01, 2006 11:33 pm

Post 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:
Post Reply