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)
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;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot