I was creating a trigger using Delimiter in MySQL phpMyAdmin and I faced a #1064 error i.e.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
I have searched at many places but I didn’t find any solution, so I decided to post the solution here after resolving that error. The problem was that I was applying Delimiter at the end of every statement after declaring it. Thus, in phpMyAdmin, whenever we define a Trigger or stored procedure, we have to follow these steps: