Tag: stored functions

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...

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...