For example lets create a stored procedure to increment salaries of employees by percentage DELIMITER $$ CREATE PROCEDURE salary_increment(increment_percent decimal(5,2)) BEGIN UPDATE employee_master ...

Why do we need stored routines?in this multi-part series i will explain the need of stored routines commonly know as stored procedures and functions , how to manage them, how to declare variables, ...

MySQL Stored Geo Functions This is a small collection of MySQL stored functions which operate on spatial fields and which may be useful filling in gaps in the built-in functionality.

These functions allow you to store arrays in a mysql blob and then do functions such as select maxarray (arrblob) from datatable group by location; This is real useful when working with stored ...