Pario TechnoBlob

A chronological documentation test project, nothing serious, really!

Tag: stored functions

Scripting

Howto backup mysql stored functions and stored procedures

This is how you can backup you MySQL database(s) and stored procedures # mysqldump –routines <dbname> Or you can backup only the stored procedures # mysqldump –no-create-db –no-create-info –no-data –routines <dbname>

Scripting

mysql alternative to PHP substr_count function

The substr_count function in PHP counts the number of substring occurrences. This post describes how to create a mysql stored function to behave just like PHP’s substr_count function. This function can be created from your mysql console delimiter || DROP FUNCTION IF EXISTS substrCount|| CREATE FUNCTION substrCount(s VARCHAR(255), ss VARCHAR(255)) RETURNS TINYINT(3) UNSIGNED LANGUAGE SQL […]