Skip to content
Advertisement

SQL : Error 1064 in my query, i cannot find why

I’ve got this to create a trigger:

And MySQL returns me

1064 – Syntax error near ” on line 14″

Someone have explanation?

Thank you all. I work to resolve it yet.

Advertisement

Answer

Did you wanted something like this ? If yes, then additional info: https://www.w3resource.com/mysql/control-flow-functions/if-function.php

The IF function does not need SELECT clause. I have tested it here: TEST

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement