SQLite Forum

Create a trigger without a name, BUG?
Login
The syntax diagram for the CREATE TRIGGER statement can be found here <https://sqlite.org/lang_createtrigger.html>.  If you can trace your way through the diagram using your provided statement, then that statement is syntactically correct.  That you may have made a spelling or semantic error is **YOUR** problem and not SQLite3's problem.

Since the statement sample you have given **IS** indeed valid syntax, the problem is that **YOU** made an error.  It is not job of the parser to second-guess your clearly stated syntax free statement on the theory that **YOU** might be an idiot and not know what you are doing.

If you wish a product that does hand-holding, then use a product that does hand holding.  Microsoft and Apple are the two best known examples of the makers of such nanny products.