Is user can create own functions in MariaDB? If yes, then how?

devquora
devquora

Posted On: Feb 22, 2018

 

Yes, the user can easily create the functions in MariaDB by following the syntax.

Create FUNCTION function-name [data type]

RETURNS return-datatype |Deterministic |Not Deterministic|

{contains SQL | NO SQL data}

|SQL Security (Definer | Invoker}

|Comment ‘comment-expression’

BEGIN

Declaration section

Executable section

END;

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    MariaDB Interview Questions

    What do you understand by the MariaDB?

    MariaDB is developed by MySQL developers. It is a popular public source under GNU GPL which is related to database management technology...

    MariaDB Interview Questions

    Mention some characteristics of MariaDB?

    It has a lot of unique features that make it more useful and wonderful to work over it than MySQL. Some features are:..

    MariaDB Interview Questions

    Which command is used to delete the table in MariaDB’s database?

    The command DROP TABLE is used to delete the table in MariaDB’s database...