Resolve Delimiter Issue While Creating Trigger Or Stored Procedure In MySQL phpMyAdmin

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: Keep on reading

Solution for SUM() in SQL query returning NULL instead zero (Differen between ISNULL and COALESCE)

When I was working on SQL queries I face this problem and then I have to shake my head to remember why this happen and what I did to solve it. So now I am documenting it here in more detail so that anyone who need help can get information here. Even I can check back when I will do same mistake 😉

Normally what happens is we use COUNT in QSL query and it return 0 if there is resolve fr that query. For example here is my table Keep on reading