MySQL Error 1064 when DELETEing

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 363,806 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,655 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 811 | Replies: 10 | Solved

Previous Post in Thread

Next Post in Thread

•

Join Date: Aug 2004

Posts: 18

Reputation: ray_broome is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

ray_broome ray_broome is offline

Offline

Newbie Poster

MySQL Error 1064 when DELETEing

May 7th, 2008

I'm trying to carry out the following delete statements

Help with Code Tags

(Toggle Plain Text)

DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1
DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num = 2277 LIMIT 1
DELETE FROM images AS i WHERE i.image_id = 805 AND i.plant_num = 2277 LIMIT 1

but i am getting the error:

Help with Code Tags

(Toggle Plain Text)

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 'AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1; DELETE FROM images A' at line 1

any idea what is causing this because everything looks okay to me.

Thanks in advance

Last edited by ray_broome : May 7th, 2008 at 2:21 pm.