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 401,608 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 3,746 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!

MySQL Error 1064 when DELETEing

•

•

Join Date: Aug 2004

Posts: 18

Reputation: ray_broome is an unknown quantity at this point

ray_broome is an unknown quantity at this point

Rep Power: 5

Solved Threads: 0

ray_broome ray_broome is offline

ray_broome is offline

Offline

Newbie Poster

MySQL Error 1064 when DELETEing

#1

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.

Reply With Quote

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 401,608

Users Online Now: 3,746

Active IRC Users: 23

Forum Threads: 130,428

Forum Posts: 667,778

Code Snippets: 888

Blogs: 147

Blog Entries: 2,136

Directory Links: 566