首页 \ 问答 \ 如何扩展此SQL查询以删除与其结果的ID匹配的所有行？(How can I extend this sql query to delete all rows which match the ID of its results?)

如何扩展此SQL查询以删除与其结果的ID匹配的所有行？(How can I extend this sql query to delete all rows which match the ID of its results?)

 我正在学习更复杂的查询。 使用以下sql，它通过表查找可能的重复项，其中基本上是x = y或y = x。 即它是相同的条目，但id是相反的列。  
SELECT 
    a.match_id as a_match_id, 
    b.match_id as b_match_id 
FROM 
    matches a, 
    matches b 
WHERE 
    a.primary_linked_id=b.secondary_linked_id 
AND 
    a.secondary_linked_id=b.primary_linked_id 
AND 
    a.date = b.date';
 
 我想要做的是，从b_match_id返回的列表中删除所有这些结果。  
 我只知道如何使用php，然后我将遍历所有这些结果并为每一行构建另一个SQL查询。 这很慢。  
 我怎么会基本上添加这样的东西：  
DELETE FROM matches WHERE match_id=b_match_id 
 
 ..所以这一切都是用1个查询完成的。 

I'm learning about more complex queries. Take the following sql, which looks through a table to find possible duplicates, where basically x = y, or y = x. ie it's the same entry, but the id's are in opposing columns. 
SELECT 
    a.match_id as a_match_id, 
    b.match_id as b_match_id 
FROM 
    matches a, 
    matches b 
WHERE 
    a.primary_linked_id=b.secondary_linked_id 
AND 
    a.secondary_linked_id=b.primary_linked_id 
AND 
    a.date = b.date';
 
What I want to do, is then from the list of b_match_id's returned, is delete all those results. 
I only know how to do this with php, where I would then loop through all those results and construct another sql query for each row. This is slow. 
How would I basically add-on something like this: 
DELETE FROM matches WHERE match_id=b_match_id 
 
.. so that it all is done with 1 query.

原文：https://stackoverflow.com/questions/35812614

更新时间：2023-09-19 12:09

最满意答案

 请检查此演示  
https://jsfiddle.net/pkwhd9vq/
 
 你必须先修复你的HTML，  
   <div class="checkmark-outer">
    <div class="checkmark-33">
    <ul>
    <li>
        <div class="fa-stack fa-1x checkmark-icon">
            <i class="fa fa-circle fa-stack-2x icon-background"></i>    
            <i class="fa fa-check fa-stack-1x icon-text"></i>
        </div>
        <div class="checkmark-inner">Option 1</div>
    </li>
    <li>
    <div class="fa-stack fa-1x checkmark-icon">
        <i class="fa fa-circle fa-stack-2x icon-background"></i>
        <i class="fa fa-check fa-stack-1x icon-text"></i>
    </div>
    <div class="checkmark-inner">Option 2</div>
</li><li>
    <div class="fa-stack fa-1x checkmark-icon">
        <i class="fa fa-circle fa-stack-2x icon-background"></i>
        <i class="fa fa-check fa-stack-1x icon-text"></i>


    </div>

    <div class="checkmark-inner">Option 3</div>
        </li>
        </ul>
        </div>
    </div>

    <div class="read-more-show">Show More</div>
 
 然后添加你必须找到所有列表项和slicewith jquery  
jQuery(document).ready(function(){    
$('.checkmark-33 ul').each(function(){ 

$(this).find('li').slice(2).wrap("<ul class='hide'></ul>");

});
$('.read-more-show').on("click",function(){
$(".hide").toggle();
});
});
 
 然后用css隐藏包装潜水  
.hide{
  display:none;

}

Please check this demo 
https://jsfiddle.net/pkwhd9vq/
 
you have to fix your html first, 
   <div class="checkmark-outer">
    <div class="checkmark-33">
    <ul>
    <li>
        <div class="fa-stack fa-1x checkmark-icon">
            <i class="fa fa-circle fa-stack-2x icon-background"></i>    
            <i class="fa fa-check fa-stack-1x icon-text"></i>
        </div>
        <div class="checkmark-inner">Option 1</div>
    </li>
    <li>
    <div class="fa-stack fa-1x checkmark-icon">
        <i class="fa fa-circle fa-stack-2x icon-background"></i>
        <i class="fa fa-check fa-stack-1x icon-text"></i>
    </div>
    <div class="checkmark-inner">Option 2</div>
</li><li>
    <div class="fa-stack fa-1x checkmark-icon">
        <i class="fa fa-circle fa-stack-2x icon-background"></i>
        <i class="fa fa-check fa-stack-1x icon-text"></i>


    </div>

    <div class="checkmark-inner">Option 3</div>
        </li>
        </ul>
        </div>
    </div>

    <div class="read-more-show">Show More</div>
 
then add you have to find all list items and slicewith jquery 
jQuery(document).ready(function(){    
$('.checkmark-33 ul').each(function(){ 

$(this).find('li').slice(2).wrap("<ul class='hide'></ul>");

});
$('.read-more-show').on("click",function(){
$(".hide").toggle();
});
});
 
then hide wrapper dive with css  
.hide{
  display:none;

}

如何扩展此SQL查询以删除与其结果的ID匹配的所有行？(How can I extend this sql query to delete all rows which match the ID of its results?)

最满意答案

相关问答

使用jQuery将不同数量的div分组到同一个类，直到“最后”类(Using jQuery to group varying number of divs wtih same class until “last” class)[2023-04-25]

使用JQuery限制重复div的数量(Limit number of repeated divs using JQuery)[2023-08-25]

使用jQuery从div添加数字(Add number from divs with jQuery)[2023-02-27]

循环通过divs jquery(looping through divs jquery)[2022-09-18]

jQuery对不同的div应用相同的功能(jQuery apply same functionality to different divs)[2021-11-15]

我的jQuery下拉菜单创建无限数量的div(My jQuery dropdown menu creates an infinite number of divs)[2022-07-07]

我如何使用jquery来计算某个类的隐藏div的数量(How do I count the number of hidden divs of a certain class with jquery)[2021-08-08]

通过jquery和ajax渲染重复div的最佳方法是什么？(what's the best way to render repeated divs via jquery and ajax?)[2022-03-12]

在div中绑定重复的div与一些不同的内容(Binding repeated divs with a bit different contents in the divs)[2023-12-31]

jQuery计算具有特定类的div内具有特定类的div的数量(jQuery count number of divs with a particular class inside a div with a particular class)[2022-04-15]

相关文章

最新问答