1 of 1

Error 4047: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Error Code

SQLSTATE

Error

Description

4047

ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE

CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Possible Causes and Solutions