August 2014 – Page 3

August 24, 2014

Using conditional expressions inside MySQL Stored Procedure

Sometimes there is need to use conditional expression inside stored procedure to control the flow of execution.We can use IF or CASE statements for this.Below is a stored procedure to check the performance of a student based on its score.Store the below stored procedure in a file called get_performance.sqlDELIMITER $$DROP PROCEDURE IF EXISTS get_performance$$CREATE PROCEDURE get_performance (score NUMERIC(8, 2), OUT result VARCHAR(11))BEGIN IF (score >= 90) THEN SET result = ‘OUTSTANDING’; ELSEIF (score >= 70 AND score < 90) THEN SET result = ‘AWESOME’; ELSEIF (score >= 60 AND score < 70) THEN SET result = ‘GOOD’; ELSEIF (score >= 40 AND score < 60) THEN SET result = ‘OK’; ELSE SET result = ‘FAIL’; END IF;END$$DELIMITER ;Execute the procedure:mysql> SOURCE get_performance.sql;Query OK, 0 rows affected, 1 warning (0.00 sec)Query OK, 0 rows affected (0.00 sec)Execute the call:mysql> CALL get_performance(67, @result);Query OK, 0 rows affected (0.00 sec)mysql> SELECT @result;+———+| @result |+———+| GOOD |+———+1 row in set (0.00 sec)Basically IF, ELSEIF check for conditions, ELSE matches any condition which has not been matched by any preceding condition and finally THEN executes the set of statements for the satisfied condition and breaks out of the conditional expression. Similarly, we can use CASE for switching to statement sections based on equality comparison with a set of unique values.
via Planet MySQL
Using conditional expressions inside MySQL Stored Procedure

August 24, 2014

Use of loops in MySQL stored procedures

Loops -> Repetitive tasks3 types of loops in MySQL stored program: – Simple loop using LOOP and END LOOP clauses- WHILE and END WHILE clauses that runs while a condition is true- REPEAT and UNTIL clauses that runs until a condition is trueTermination of loop -> LEAVE statement.I will demonstrate the use of loops the simple loop way.Simple counter from 1 to 10:Store below stored procedure in a file named my_loop.sqlDELIMITER $$DROP PROCEDURE IF EXISTS my_loop$$CREATE PROCEDURE my_loop()BEGIN DECLARE counter INT DEFAULT 0; my_loop: LOOP SET counter = counter + 1; IF counter = 10 THEN LEAVE my_loop; END IF; END LOOP my_loop; SELECT CONCAT(‘Done counting up to ‘, counter) AS result;END$$DELIMITER ;Execute the stored procedure:mysql> SOURCE my_loop.sqlQuery OK, 0 rows affected, 1 warning (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql> CALL my_loop();+————————+| result |+————————+| Done counting up to 10 |+————————+1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)Explaining simply, we are defining a counter that starts with 0 and a LOOP labelled my_loop that increments from 0 onward and a condition inside to check for counter value of 10, when the loop terminates through the use of LEAVE clause. You can give a try to the other loop clauses 🙂
via Planet MySQL
Use of loops in MySQL stored procedures

August 21, 2014

A bad boss can make the whole team mean

Bosses who are abusive to one employee can actually cause conflict among the whole team, which hurts productivity, according to … Continued

The post A bad boss can make the whole team mean appeared first on Futurity.

via Futurity
A bad boss can make the whole team mean

August 20, 2014

Ten Simple Ways to Make Your Office Look Cleaner Than It Really Is

Your office is your home away from home, and keeping the office clean is very important to your everyday work life. While it’d be great if you could clean up everyday, simply giving the appearance that things are organized can help you not look like an absolute slob.

This post originally appeared on GetVoIP.

The truth is that you’ll probably hold off on the bigger cleaning chores until you absolutely need to—that us, until somebody important knocks on the door, forcing you to de-clutter everything like a highly-efficient cleaning ninja. But keeping just a little order will go a long way.

Here are ten things you can do so your office looks good when you need it to.