Updated on 2025-06-07 GMT+08:00

U0400040: GaussDB (M-compatible mode) does not support the TABLE command

Description

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Destination database type and version: compatible with GaussDB V2.0-8.100 (M-compatible mode) and GaussDB V2.0-8.200 (M-compatible mode)

Syntax Example

The TABLE statement in a MySQL database can return table data. The TABLE t; statement returns the same results as the SELECT * FROM t; statement. This error is reported because GaussDB does not support the TABLE command of MySQL, for example:

TABLE t;

Suggestion

Use the SELECT statement instead of TABLE, for example:

SELECT * FROM t;