framework icon indicating copy to clipboard operation
framework copied to clipboard

数据库 -> 删除数据 软删除不生效

Open 13191868165 opened this issue 3 years ago • 0 comments

https://www.kancloud.cn/manual/thinkphp6_0/1037536

//软删除数据 使用delete_time字段标记删除

Db::name('admin')
            ->where('id', 1)
            ->useSoftDelete('delete_time', time())
            ->delete();

生成删除SQL语句:UPDATE `ims_admin`  SET `delete_time` = :ThinkBind_1_1940990104_  WHERE  `id` = :ThinkBind_2_212042888_  
Db::name('admin')
            ->where('id', 1)
            ->useSoftDelete('delete_time', time())
            ->fetchSql()
            ->delete();

生成删除SQL语句:DELETE FROM `ims_admin` WHERE  `id` = :ThinkBind_1_1306225866_ 

问题可能是出在这里: image

src/db/BaseQuery.php -> delete() {} 里面 软删除执行的:$this->connection->update($this);

src/db/Fetch.php -> delete() {} 里面 软删除执行的:$this->builder->delete($this->query);

13191868165 avatar Jan 07 '22 07:01 13191868165