pingcap / pingcap/tidb

Support the function of returning like pg

Open
#58,939 4 comments 12 reactions 0 assignees View on GitHub
compatibility-mariadb type/compatibility type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

**Is your feature request related to a problem? Please describe:**

Atomic retrieval of deleted/update/insert updated records to avoid transactions and unnecessary select and reduce code complexity

**Describe the feature you'd like:**

e.g
```sql
INSERT INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING id;
UPDATE table_name SET column1 = value1, ... WHERE condition RETURNING column1, column2, ...;
DELETE FROM table_name WHERE condition RETURNING column1, column2, ...;
```

**Describe alternatives you've considered:**

**Teachability, Documentation, Adoption, Migration Strategy:**

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.