且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在sqlite中返回已删除的行

更新时间:2023-12-04 21:11:34

DELETE 语句有没有 OUTPUT 子句.

The DELETE statement has no OUTPUT clause.

执行SELECT后,所有重要数据都在缓存中,因此DELETE会运行得很快.

After doing the SELECT, all the important data is in the cache, so the DELETE will run quickly.

因为 SELECT 加 DELETE 是唯一的方式,所以它是最有效的方式.

And because SELECT plus DELETE is the only way, it is the most efficient way.