StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQL DELETE with JOIN
primarykey
Id
7852589
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2011-10-21T16:44:24.907
FavoriteCount
0
LastActivityDate
2011-10-21T21:37:47.887
LastEditDate
2011-10-21T21:37:47.887
LastEditorUserId
1004952
OwnerUserId
1004952
ParentId
0
PostTypeId
1
Score
0
ViewCount
445
LastEditorDisplayName
text
Body
Why the following query doesn't work? What is the best way to delete the following five tables row in SQL? How can I fix it? <pre><code>//$id = $this->input->post('id'); $id = '65'; $this->db->query(" DELETE table_1, table_2, table_3, table_4, table_5 FROM table_1 JOIN table_2 ON table_1.id = table_2.rela JOIN table_3 ON table_2.h_id = table_3.h_id JOIN table_4 ON table_1.id = table_4.rela JOIN table_5 ON table_2.h_id = table_5.h_id WHERE table_1.id =".floor($id)); </code></pre> Update: table_1.id => this have id <code>65</code> table_2.rela => this have rela <code>65</code> table_2.h_id => this have h_id <code>11</code> table_3.h_id => this have h_id <code>11</code> table_4.rela => this have rela <code>65</code> table_5.h_id => this have h_id <code>11</code> Update 2: in <code>table_1.id</code> one row have <code>65</code> and also is for <code>table_2</code> and <code>table_4</code> that have <code>rela 65</code> (<code>table_1.id = table_2.rela => 65 = 65, table_1.id = table_4.rela => 65 = 65</code>) now in <code>table_2</code> we have a column name h_id that have number <code>11</code> and it is set with <code>h_id</code> in other tables[<code>table_3</code>, <code>table_5</code>]. How with there this relationship can get a <code>id</code> from <code>table_1</code> and delete other rows in their tables. i mane is this: (with have one <code>id</code> from <code>table_1</code> we can delete other rows relationship with it in their tables, in following is a example from this relationship) <blockquote> <code>table_1.id</code> = <code>65</code> => <code>table_4.rela</code> = <code>65</code> => <code>table_2.rela</code> = <code>65</code> -> <code>table_2.h_id</code> = <code>11</code> => <code>table_3.h_id</code> = <code>11</code> => <code>table_5.h_id</code> = <code>11</code>. </blockquote> UPDATE 3: Who can help me for my problem, there is a guy? I don't get still answers for Question's.
Tags
<php><mysql><codeigniter><join>
Title
SQL DELETE with JOIN
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJimBo
UserOwnerUserId
1. USJimBo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POSQL DELETE with JOIN
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
2. VO
 singulars
 PostPostId
 POSQL DELETE with JOIN
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.