Run Simple SQL statement on dbForge query window directly
I want to run a sql statement on dbForge query window, but got error:

    if (ifnull(null,'s') = 's') then
    select 's';
    end if;

Error:

    1 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 'if (ifnull(null,'s') = 's') then
    select 's'' at line 2 SQL1.sql 2 1

 


I have to put that statement within a stored procedure to test it.

How to run the statement directly on query window, like SQL Server management studio.


Run Simple SQL statement on dbForge query window directly
===

I want to run a sql statement on dbForge query window, but got error:

    if (ifnull(null,'s') = 's') then
    select 's';
    end if;

Error:

    1 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 'if (ifnull(null,'s') = 's') then
    select 's'' at line 2 SQL1.sql 2 1

 


I have to put that statement within a stored procedure to test it.

How to run the statement directly on query window, like SQL Server management studio.

