Monthly Archives: January 2015

MySQL IF ELSE Statement

MySQL IF…ELSE statement can only be used inside stored procedure. They will not work in regular scope. The syntax is DELIMITER // CREATE PROCEDURE IfTest() BEGIN if(@test = 2) then begin select ‘I know you’; end; else begin select ‘I … Continue reading

Posted in Uncategorized | Leave a comment

MySQL – Working with Variables

Variables in MySQL work quite different than how they work in SQL Server. I stumbled upon quite a few things when working with Variables in MySQL. Here is a short overview of it Declare Variables No need to declare variables … Continue reading

Posted in Uncategorized | Leave a comment