Quick onboard
Deployment
Data Modeling
Connection
Migration
Query
Operations and Maintenance
Common Maintenance
Partition
Backup and Restore
Expansion
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool guide
Data Type
Storage Engine
Executor
Stream
DR (Disaster Recovery)
Configuration
Index
Extension
SQL Reference
Abort the current transaction.
ROLLBACK [WORK | TRANSACTION]ROLLBACK rolls back the current transaction and causes all updates made by the transaction to be discarded.
WORK
TRANSACTION
Use COMMIT to successfully submit the current transaction.
If not inside the transaction, issuing ROLLBACK will not cause any harm, but will trigger a warning message.
To discard all changes in the current transaction:
ROLLBACK;The SQL standard specifies only two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command fully meets the requirements.