Functions wizard (MySQL)
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:
- Open a creation wizard for a function. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Functions - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- 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. |