{"id":92,"date":"2023-05-06T03:20:50","date_gmt":"2023-05-06T03:20:50","guid":{"rendered":"https:\/\/itnotes.apjsoftwares.com\/?p=92"},"modified":"2023-05-06T03:20:50","modified_gmt":"2023-05-06T03:20:50","slug":"what-are-mysql-functions-in-php","status":"publish","type":"post","link":"https:\/\/itnotes.apjsoftwares.in\/index.php\/2023\/05\/06\/what-are-mysql-functions-in-php\/","title":{"rendered":"What are MySQL functions in PHP?"},"content":{"rendered":"\n

Creating a function<\/strong><\/p>\n\n\n\n

In MySQL, Function can also be created. A function always returns a value using the return statement. The function can be used in SQL queries.<\/p>\n\n\n\n

Syntax<\/strong><\/p>\n\n\n\n

CREATE FUNCTION function_name [ (parameter datatype [, parameter datatype]) ]   <\/p>\n\n\n\n

RETURNS return_datatype  <\/p>\n\n\n\n

BEGIN  <\/p>\n\n\n\n

Declaration_section  <\/p>\n\n\n\n

Executable_section  <\/p>\n\n\n\n

END;  <\/p>\n\n\n\n

Parameter:<\/strong><\/p>\n\n\n\n

Function_name: name of the function<\/p>\n\n\n\n

Parameter: number of parameters. It can be one or more than one.<\/p>\n\n\n\n

return_datatype: return value datatype of the function<\/p>\n\n\n\n

declaration_section: all variables are declared.<\/p>\n\n\n\n

executable_section: code for the function is written here.<\/p>\n\n\n\n

DELIMITER $$   <\/p>\n\n\n\n

CREATE FUNCTION get_designation_name(d_id INT) RETURNS VARCHAR( 20 )   <\/p>\n\n\n\n

BEGIN   <\/p>\n\n\n\n

DECLARE de_name VARCHAR( 20 ) DEFAULT “”;  <\/p>\n\n\n\n

SELECT name INTO de_name FROM designation WHERE id = d_id;  <\/p>\n\n\n\n

RETURN de_name;  <\/p>\n\n\n\n

END $$<\/p>\n\n\n\n

Drop a function<\/strong><\/p>\n\n\n\n

In MySQL Function can also be dropped. When A function id is dropped, it is removed from the database.<\/p>\n\n\n\n

Syntax:<\/strong><\/p>\n\n\n\n

Drop function [ IF EXISTS ] function_name;  <\/p>\n\n\n\n

Parameter<\/strong><\/p>\n\n\n\n

function_name: name of the function to be dropped.<\/p>\n\n\n\n

drop function get_designation_name;<\/p>\n","protected":false},"excerpt":{"rendered":"

Creating a function In MySQL, Function can also be created. A function always returns a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/92"}],"collection":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":1,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":93,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/92\/revisions\/93"}],"wp:attachment":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}