v.22.5Improvement

Option compatibility_ignore_auto_increment_in_create_table Simplifies MySQL Migration

Official CH changelog text
Option compatibility_ignore_auto_increment_in_create_table allows ignoring AUTO_INCREMENT keyword in a column declaration to simplify migration from MySQL. #37178 (Igor Nikonov).
Adds the compatibility_ignore_auto_increment_in_create_table option to allow ClickHouse to ignore the AUTO_INCREMENT keyword in column declarations.

Why it matters

This feature simplifies migration from MySQL by allowing ClickHouse to bypass the AUTO_INCREMENT attribute in CREATE TABLE statements, which is not natively supported.

How to use it

Enable the compatibility_ignore_auto_increment_in_create_table option when creating tables to ignore AUTO_INCREMENT in column definitions and ensure smoother MySQL to ClickHouse migrations.

Related resources

PreviousNext