TiDB supports the ability to assert that DDL changes will use a particular ALTER algorithm. This is only an assertion, and does not change the actual algorithm which will be used to modify the table.

For an ALTER TABLE statement, the order of execution in TiDB is one change after another from left to right, which is incompatible with MySQL in some cases. Changes of the Reorg-Data types on primary ...

Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions. To add, drop, or modify a ...

You create a CLOB in Oracle through the database's Structured Query Language, or SQL. Using SQL's "ALTER TABLE" statement, you add a CLOB data item to an existing table in your business' database.