Functions wizard (MySQL)

From RapidSQL
Jump to: navigation, search

Go Up to MySQL object wizards

The MySQL Functions Wizard lets you build and submit a CREATE FUNCTION declaration, specifying a return type and the owning library.

Note: Functions must be written in C or C++, your operating system must support dynamic loading, and you must have compiled mysqld dynamically (not statically).

To create a new function using a wizard:

  1. Open a creation wizard for a function. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Functions - Properties

When creating or editing a function, this tab/panel lets you work with the following settings:

Required Information Description

Function Name

In 64 characters or less, you can name your function.

Return Value

STRING, REAL (also known as Double), INTEGER

Shared Object Library

Identify the file that holds the library where your functions are stored.

Aggregate

Check the box if the function you are creating will collapse a large amount of data into a single output, or aggregate the data.