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

U0400056: The table name is missing before FROM in DELETE

Description

No table name is specified before FROM in the DELETE statement for an M-compatible GaussDB instance.

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: GaussDB (M-compatible mode)
Syntax Example
delete from test_code t;

Suggestion

Method 1:

Add a table alias before FROM, for example:

delete t from test_code t;

Method 2:

Delete the table alias, for example:

delete from test_code;