I just created a MySQL Table called "trigger". The Problem now: I want to "drop table trigger;" This is not working. (Syntax error...) because it recognizes trigger not as name but as a trigger.

How do I do drop a table Named "trigger"?

CodePudding user response：

You can escape a name with backticks. In your case:

DROP TABLE `trigger`;