v.24.3Improvement

Add Support for START TRANSACTION Syntax in MySQL

Official CH changelog text
Add support for START TRANSACTION syntax typically used in MySQL syntax, resolving https://github.com/ClickHouse/ClickHouse/discussions/60865. #60886 (Zach Naimon).
Added support for the START TRANSACTION syntax commonly used in MySQL, enabling users to begin transactions using this familiar command in ClickHouse.

Why it matters

This feature addresses the need for compatibility with MySQL transaction syntax, allowing users migrating from MySQL or using client applications with standard SQL transaction commands to initiate transactions seamlessly in ClickHouse.

How to use it

Users can start transactions by executing the command:

START TRANSACTION;


This command behaves equivalently to BEGIN TRANSACTION and initiates a transaction block in ClickHouse.

Related resources

PreviousNext