dotnetcore / dotnetcore/FreeSql
mysql和postgresql悲观锁skip locked
Open
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
#### Feature 特性
mysql和postgresql悲观锁for update语句的skip locked后缀可以跳过被锁定的行
```c#
// c# code
```
#### 简要描述原因
功能增强
```c#
// c# code
```
#### 使用场景
任务队列场景,每次取一个任务跳过正在处理的任务
```c#
fsql.Select().Where(xxx).ForUpdate(skipLocked: true).ToOne();
// c# code
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.