{"id":1382,"date":"2012-05-25T13:52:47","date_gmt":"2012-05-25T13:52:47","guid":{"rendered":"http:\/\/galhano.com\/blog\/?p=1382"},"modified":"2012-05-25T13:53:57","modified_gmt":"2012-05-25T13:53:57","slug":"mysql-create-function-syntax","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=1382","title":{"rendered":"MySQL, CREATE FUNCTION Syntax"},"content":{"rendered":"

The general syntax of Creating a Function is :<\/strong><\/p>\n

[sql] CREATE FUNCTION func_name ([func_parameter[,…]]) RETURNS type routine_body[\/sql]<\/p>\n

func_name : Function name
\nfunc_parameter : param_name type
\ntype : Any valid MySQL datatype
\nroutine_body : Valid SQL procedure statement<\/p>\n

\u00a0The RETURN clause is mandatory for FUNCTION<\/strong> . It used to indicate the return type of function.<\/p>\n

Now we are describing you a simple example a function. This function take a parameter and it is used to perform an operation by using an SQL function and return the result. In this example there is no need to use delimiter because it contains no internal ; statement delimiters. Example :<\/p>\n

[sql]
\nCREATE FUNCTION func(str CHAR(20))
\nRETURNS CHAR(50)
\nRETURN CONCAT(‘WELCOME TO, ‘,str,’!’);
\n[\/sql]<\/p>\n

Query OK, 0 rows affected (0.00 sec)<\/p>\n

[sql] SELECT func(‘Galhano.com’);[\/sql]<\/p>\n

 <\/p>\n

[text]
\n+————————+
\n| func(‘Galhano.com’)\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+————————+
\n| WELCOME TO, Galhano.com |
\n+————————+
\n1 row in set (0.00 sec)
\n[\/text]<\/p>\n

http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/create-procedure.html<\/p>\n

http:\/\/www.roseindia.net\/mysql\/mysql5\/stored-procedures-and-functions.shtml<\/p>\n","protected":false},"excerpt":{"rendered":"

The general syntax of Creating a Function is : [sql] CREATE FUNCTION func_name ([func_parameter[,…]]) RETURNS type routine_body[\/sql] func_name : Function name func_parameter : param_name type type : Any valid MySQL datatype routine_body : Valid SQL procedure statement \u00a0The RETURN clause is mandatory for FUNCTION . It used to indicate the return type of function. Now […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1382","post","type-post","status-publish","format-standard","hentry","category-mysql","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1382"}],"version-history":[{"count":4,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1382\/revisions"}],"predecessor-version":[{"id":1386,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1382\/revisions\/1386"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1382"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}