CREATE DEFINER=`root`@`%` FUNCTION `titlecase`(input TEXT) RETURNS text CHARSET latin1
BEGIN
DECLARE pointercari INT;
DECLARE pointerlama INT;
DECLARE n INT;
DECLARE output TEXT;
SET n := LENGTH(input);
I wrote what have I did before in this blog, as an IT practician, such as build system information, database, programming, networking, research, etc
|
||
Showing posts with label stored procedure. Show all posts
Showing posts with label stored procedure. Show all posts
Wednesday, April 20, 2011
Some Mysql stored procedure example
CREATE DEFINER=`root`@`%` FUNCTION `titlecase`(input TEXT) RETURNS text CHARSET latin1
BEGIN
DECLARE pointercari INT;
DECLARE pointerlama INT;
DECLARE n INT;
DECLARE output TEXT;
SET n := LENGTH(input);
Subscribe to:
Posts (Atom)