Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Supper Baby
Forum Commoner
Posts: 27 Joined: Tue Aug 01, 2006 11:33 pm
Post
by Supper Baby » Wed Aug 16, 2006 12:23 am
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 ??
RobertGonzalez
Site Administrator
Posts: 14293 Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA
Post
by RobertGonzalez » Wed Aug 16, 2006 12:25 am
Did you even look at this?
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 » Wed Aug 16, 2006 11:58 am
Everah wrote: Did you even look at this?
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