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

Export Oracle database using Oracle SQL Developer

Now it’s time to export your Oracle database with ease. This is the easiest method to export Oracle database I found so far. So let us start the exercise.

First thing you need for this exercise is Oracle SQL Developer installed on your system. For using Oracle SQL Developer you must have Java installed on your system. If Java is installed on your system and SQL Developer can’t find the file then it will show a dialog box to locate the java.exe file. After installing Java and selecting java.exe from the dialog box your SQL Developer will start and will show some useful tips. Read these tips or skip (as you wish)… Keep on reading