I create a table as follow:
create table INTERFACE_INFO_PK_SIMPLE
(
API_ID VARCHAR(128) not null primary key,
API_METHOD VARCHAR(24),
API_PATH VARCHAR(1024),
API_STATUS VARCHAR(8),
API_COMMENT VARCHAR(510),
API_TYPE VARCHAR(48)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
In my mac os the 'lower_case_table_names' is 2 and I find the table name is lowercase in binlog file.
Does the config 'lower_case_table_names' have relationship with whther table name is case sensitive in binlog file?
If use a linux os pc and set 'lower_case_table_names=0', will the table name be upper case like 'INTERFACE_INFO_PK_SIMPLE' in binlog file in my case?