Sfrgttk

Why are the books in the Game of Thrones citadel library shelved spine inwards?

Potential client has a problematic employee I can't work with

Why zero tolerance on nudity in space?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Can you tell from a blurry photo if focus was too close or too far?

Boss asked me to sign a resignation paper without a date on it along with my new contract

Is this ordinary workplace experiences for a job in Software Engineering?

Strange "DuckDuckGo dork" takes me to random website

How to politely refuse in-office gym instructor for steroids and protein

How should I handle players who ignore the session zero agreement?

How do you funnel food off a cutting board?

Square Root Distance from Integers

Play Zip, Zap, Zop

How does Leonard in "Memento" remember reading and writing?

Globe trotting Grandpa. Where is he going next?

Why does magnet wire need to be insulated?

What language shall they sing in?

Why does photorec keep finding files after I have filled the disk free space as root?

Eww, those bytes are gross

Why was Lupin comfortable with saying Voldemort's name?

Plausible reason for gold-digging ant

Explanation of a regular pattern only occuring for prime numbers

Is there any risk in sharing info about technologies and products we use with a supplier?

Limits of a density function

Returning a set datatype from MariaDB function

stored procedure returns ERROR 1305 (42000): FUNCTION does not existIn PostgreSQL, is there a type-safe first() aggregate function?Returning true or false in a custom functionHow to set delayed replication with MariaDB 10.0.11I try to insert this data into this tables but i got errror with High prority.I use MariaDBHow can I use function's parameter in it?Mariadb 10.1.25: create type ERROR 1064 (42000)ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDBChanging master for channel gives syntax errorCan MariaDB or MySQL cast as bigint, getting an error: … right syntax to use near 'bigint)'?

0

Given below is the syntax for the MariaDB's CREATE FUNCTION:

CREATE [OR REPLACE]

    [DEFINER = {user | CURRENT_USER | role | CURRENT_ROLE }]

    [AGGREGATE] FUNCTION [IF NOT EXISTS] func_name ([func_parameter[,...]])

    RETURNS type

    [characteristic ...]

    RETURN func_body





func_parameter:

    param_name type





type:

    Any valid MariaDB data type





characteristic:

    LANGUAGE SQL

  | [NOT] DETERMINISTIC

  | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

  | SQL SECURITY { DEFINER | INVOKER }

  | COMMENT 'string'





func_body:

    Valid SQL procedure statement

The type parameter accepts any valid MariaDB data type. I tried to return a set:

delimiter //

create function get_a_set ()

  returns set

  begin

    RETURN SET('a' , 'b');

  end //



delimiter ;

But I am getting a syntax error in the following line: RETURN SET('a', 'b');

The exact error is given below:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'begin

    RETURN SET('a' , 'b');

  end' at line 3

Any help would be greatly appreciated. Thanks!

mariadb functions mariadb-10.3

share

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82

New contributor

KAUSHAL KISHORE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

Given below is the syntax for the MariaDB's CREATE FUNCTION:

CREATE [OR REPLACE]

    [DEFINER = {user | CURRENT_USER | role | CURRENT_ROLE }]

    [AGGREGATE] FUNCTION [IF NOT EXISTS] func_name ([func_parameter[,...]])

    RETURNS type

    [characteristic ...]

    RETURN func_body





func_parameter:

    param_name type





type:

    Any valid MariaDB data type





characteristic:

    LANGUAGE SQL

  | [NOT] DETERMINISTIC

  | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

  | SQL SECURITY { DEFINER | INVOKER }

  | COMMENT 'string'





func_body:

    Valid SQL procedure statement

The type parameter accepts any valid MariaDB data type. I tried to return a set:

delimiter //

create function get_a_set ()

  returns set

  begin

    RETURN SET('a' , 'b');

  end //



delimiter ;

But I am getting a syntax error in the following line: RETURN SET('a', 'b');

The exact error is given below:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'begin

    RETURN SET('a' , 'b');

  end' at line 3

Any help would be greatly appreciated. Thanks!

mariadb functions mariadb-10.3

share

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82

New contributor

KAUSHAL KISHORE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Given below is the syntax for the MariaDB's CREATE FUNCTION:

CREATE [OR REPLACE]

    [DEFINER = {user | CURRENT_USER | role | CURRENT_ROLE }]

    [AGGREGATE] FUNCTION [IF NOT EXISTS] func_name ([func_parameter[,...]])

    RETURNS type

    [characteristic ...]

    RETURN func_body





func_parameter:

    param_name type





type:

    Any valid MariaDB data type





characteristic:

    LANGUAGE SQL

  | [NOT] DETERMINISTIC

  | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

  | SQL SECURITY { DEFINER | INVOKER }

  | COMMENT 'string'





func_body:

    Valid SQL procedure statement

The type parameter accepts any valid MariaDB data type. I tried to return a set:

delimiter //

create function get_a_set ()

  returns set

  begin

    RETURN SET('a' , 'b');

  end //



delimiter ;

But I am getting a syntax error in the following line: RETURN SET('a', 'b');

The exact error is given below:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'begin

    RETURN SET('a' , 'b');

  end' at line 3

Any help would be greatly appreciated. Thanks!

mariadb functions mariadb-10.3

share

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82

New contributor

KAUSHAL KISHORE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

CREATE [OR REPLACE]

    [DEFINER = {user | CURRENT_USER | role | CURRENT_ROLE }]

    [AGGREGATE] FUNCTION [IF NOT EXISTS] func_name ([func_parameter[,...]])

    RETURNS type

    [characteristic ...]

    RETURN func_body





func_parameter:

    param_name type





type:

    Any valid MariaDB data type





characteristic:

    LANGUAGE SQL

  | [NOT] DETERMINISTIC

  | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }

  | SQL SECURITY { DEFINER | INVOKER }

  | COMMENT 'string'





func_body:

    Valid SQL procedure statement

delimiter //

create function get_a_set ()

  returns set

  begin

    RETURN SET('a' , 'b');

  end //



delimiter ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'begin

    RETURN SET('a' , 'b');

  end' at line 3

share

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82

New contributor

KAUSHAL KISHORE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82

New contributor

KAUSHAL KISHORE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82

New contributor

KAUSHAL KISHORE is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

KAUSHAL KISHOREKAUSHAL KISHORE

82