multiple table delete

Question

5.00/5 (1 vote)

See more:

I have been trying to execute this sql syntax. its to delete from multiple tables but i cant seem to get it right. i checked to make sure it conforms with the one in the mysql manual but it still wont work. the debugger tells me there is a unnecessary comma(,) somewhere. any help. the 'id' field is already set in the code

sql = "delete from apps, contacts, firstdeg, hnd, interview, other, secdeg, thirddeg using apps join contacts on apps.FileLoc = contacts.FileLoc join firstdeg on apps.FileLoc = firstdeg.FileLoc join hnd on apps.FileLoc = hnd.FileLoc join interview on apps.FileLoc = interview.FileLoc join other on apps.FileLoc = other.FileLoc join secdeg on apps.FileLoc = secdeg.FileLoc join thirddeg on apps.FileLoc = thirddeg.FileLoc where apps.FileLoc = '"+id+"'";

Posted 12-Jan-11 23:23pm

Member 7250221

Add a Solution

2 solutions

Solution 1

The general syntax is:

DELETE FROM tablename WHERE condition

Posted 12-Jan-11 23:25pm

Thomas Krojer

Comments

[no name] 13-Jan-11 5:39am

yes, but i want to delete from multiple tables and its giving me problems

Thomas Krojer 13-Jan-11 11:02am

ok, I checked the manual now. check your statement between using and join ... in my manual it looks a bit different.

[no name] 13-Jan-11 11:35am

thanks i think the cascade method is simpler

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Аslam Iqbal · Accepted Answer · 2011-01-13T00:37:00

Solution 2

You don't have delete from multiple table. Use cascade while deleting. Another records from other tables will be automatically deleted if there is a relation. To know about cascade google it. If there is no relation btwn tables just make separate statements.

Posted 13-Jan-11 0:37am

Аslam Iqbal

Updated 13-Jan-11 0:39am

v2