In MySQL mode of OceanBase Database, you can change the row format, change the block size, change the character set, and rename a table.
Change the row format
Syntax:
ALTER TABLE table_name ROW_FORMAT = {DEFAULT | DYNAMIC | FIXED | COMPRESSED | REDUNDANT | COMPACT};
Syntax:
obclient> ALTER TABLE t1 ROW_FORMAT = COMPRESSED;
Query OK, 0 rows affected
Change the block size
Syntax:
ALTER TABLE table_name BLOCK_SIZE = value;
Sample code:
obclient> ALTER TABLE t1 BLOCK_SIZE = 1024;
Query OK, 0 rows affected
Convert a character set
Syntax:
ALTER TABLE table_name CONVERT TO CHARACTER SET charset_name;
Sample code:
obclient> ALTER TABLE test_collation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Query OK, 0 rows affected
Rename a table
Syntax:
ALTER TABLE old_tbl_name RENAME TO new_tbl_name;
Sample code:
obclient> ALTER TABLE t1 RENAME TO t2;
Query OK, 0 rows affected