在单个查询中更新多个diffrenet编号

brqmpdu1  于 2021-06-19  发布在  Mysql
关注(0)|答案(1)|浏览(313)

我在customer表中有一个customer表我有两个字段accounts和status:

我需要这样的输出:

我有1000个帐户,需要更新1000个数字状态=1。
在客户表中有200000个帐户,但我只更新了选定的1000个帐户。如何更新这些选定的帐户?

qc6wkl3g

qc6wkl3g1#

试试这个

$sql = "select * from customer where 'selected account'";

//execute query

//after execute query you have get selected record after that loop that record and update all selected record
while(){
    $sql = "update customer set status='1' where id='id from selected record'";
    //execute query
}

相关问题