首页 \ 问答 \ 如果我的ID存在于结果中，请检查MySQL表(Check in MySQL table if my ID exist in the results)

如果我的ID存在于结果中，请检查MySQL表(Check in MySQL table if my ID exist in the results)

 如果我的ID存在于结果中并且返回TRUE，如何检查MySQL表，但这有点复杂，因为我想检查记录的GROUP而不是该GROUP的最后一个，下面的代码用于表和查询不行，我想检查我的$session_user_id存在于GROUP OF auction_bid_item_id但不检查最后一行，因为最后一行是WINNING ROW。  
CREATE TABLE `auction_bids` (   
    `auction_bid_id` int(11) NOT NULL AUTO_INCREMENT,   
    `auction_bid_user_id` int(11) NOT NULL,  
    `auction_bid_seller_id` int(11) NOT NULL,   
    `auction_bid_item_id` int(11) NOT NULL,   
    PRIMARY KEY (`auction_bid_id`) 
);
 
 MySQL查询：  
SELECT * FROM auction_bids 
WHERE auction_bid_user_id = '$session_user_id' 
GROUP BY auction_bid_item_id;

How to check in MySQL table if my ID exist in the results and return TRUE, but this is a little complicated as I would like to check GROUP of records and not the last one from that GROUP, code below for the table and query which doesn't work, I would like to check if my $session_user_id exist in the GROUP OF auction_bid_item_id but not check last row as the last row is a WINNING ROW. 
CREATE TABLE `auction_bids` (   
    `auction_bid_id` int(11) NOT NULL AUTO_INCREMENT,   
    `auction_bid_user_id` int(11) NOT NULL,  
    `auction_bid_seller_id` int(11) NOT NULL,   
    `auction_bid_item_id` int(11) NOT NULL,   
    PRIMARY KEY (`auction_bid_id`) 
);
 
MySQL Query:  
SELECT * FROM auction_bids 
WHERE auction_bid_user_id = '$session_user_id' 
GROUP BY auction_bid_item_id;

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

更新时间：2022-10-25 20:10

最满意答案

 “从多个键中删除数据”：  
function batch_remove($key=null, $columns=null, $super_column=null, $write_consistency_level=null) {

    $timestamp = CassandraUtil::get_time();
    $deletion = new cassandra_Deletion();
    $deletion->timestamp = $timestamp;

    if ($super_column !== null) $deletion->super_column = $this->pack_name($super_column, true);
    else $deletion->super_column = null;

    if ($columns !== null) {
        $predicate = $this->create_slice_predicate($columns, '', '', false, self::DEFAULT_COLUMN_COUNT);
        $deletion->predicate = $predicate;
    }

    $mutation = new cassandra_Mutation();
    $mutation->deletion = $deletion;

    if (is_array($key) && count($key) >= 1) {

        $mut_map = array();
        foreach($key as $v) {
            $packed_key[$v] = $this->pack_key($v);
            $mut_map[$v] = array($this->column_family => array($mutation));
        }

        return $this->pool->call("batch_mutate", $mut_map, $this->wcl($write_consistency_level));

    } else return false;

}

//delete name1, name2, name3 from key1, key2 in a single call
$column_family->batch_remove(array(key1, key2), array(name1, name2, name3));

"delete data from multiple keys": 
function batch_remove($key=null, $columns=null, $super_column=null, $write_consistency_level=null) {

    $timestamp = CassandraUtil::get_time();
    $deletion = new cassandra_Deletion();
    $deletion->timestamp = $timestamp;

    if ($super_column !== null) $deletion->super_column = $this->pack_name($super_column, true);
    else $deletion->super_column = null;

    if ($columns !== null) {
        $predicate = $this->create_slice_predicate($columns, '', '', false, self::DEFAULT_COLUMN_COUNT);
        $deletion->predicate = $predicate;
    }

    $mutation = new cassandra_Mutation();
    $mutation->deletion = $deletion;

    if (is_array($key) && count($key) >= 1) {

        $mut_map = array();
        foreach($key as $v) {
            $packed_key[$v] = $this->pack_key($v);
            $mut_map[$v] = array($this->column_family => array($mutation));
        }

        return $this->pool->call("batch_mutate", $mut_map, $this->wcl($write_consistency_level));

    } else return false;

}

//delete name1, name2, name3 from key1, key2 in a single call
$column_family->batch_remove(array(key1, key2), array(name1, name2, name3));

如果我的ID存在于结果中，请检查MySQL表(Check in MySQL table if my ID exist in the results)

最满意答案

相关问答

批处理突变在Cassandra中是否是原子的？(Are batch mutations atomic in Cassandra?)[2024-04-24]

在Yii中使用Phpcassa(Using Phpcassa in Yii)[2023-06-25]

cassandra和hadoop - 实时与批量(cassandra and hadoop - realtime vs batch)[2022-03-01]

phpcassa cassandra批量突变(phpcassa cassandra batch mutation)[2023-11-21]

什么是cassandra的突变？(What is mutation in cassandra?)[2023-05-18]

phpcassa返回的列数较少(phpcassa returns less number of records with columns)[2022-06-27]

phpcassa连接池(phpcassa connection pools)[2022-01-11]

Cassandra与批量更新不一致(Cassandra inconsistencies with batch updates)[2022-10-23]

使用phpcassa对cassandra进行多重查询(Multiget query to cassandra with phpcassa)[2023-05-09]

cassandra中IntegerType的一些问题(some problems with IntegerType in cassandra)[2022-04-27]

相关文章

最新问答