«
thinkPHP5数据删除语法

时间:2021-11-17    作者:Thinkphp    分类: ThinkPHP


删除数据
// 根据主键删除
Db::table('think_user')->delete(1);
Db::table('think_user')->delete([1,2,3]);

// 条件删除
Db::table('think_user')->where('id',1)->delete();
Db::table('think_user')->where('id','<',10)->delete();


最终生成的SQL语句可能是:

DELETE FROM think_user WHERE id = 1
DELETE FROM think_user WHERE id IN (1,2,3)
DELETE FROM think_user WHERE id = 1
DELETE FROM think_user WHERE id < 10



通过上面可以看出,无论TP的删除语法是什么样的,都是 通过PHP原生语句转化来的;

标签: thinkphp