Skip navigation links

The world's most popular open source database

Login | Register

Developer Zone
Downloads
Documentation

MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
MySQL Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents
  - MySQL 5.7 Manual
  - MySQL 5.6 Manual
  - MySQL 5.5 Manual
  - MySQL 5.1 Manual
  - MySQL 5.0 Manual
  - MySQL 3.23/4.0/4.1 Manual

Search manual:

MySQL 5.6 Reference Manual :: 13 SQL Statement Syntax :: 13.1 Data Definition Statements :: 13.1.12 CREATE FUNCTION Syntax

« 13.1.11 CREATE EVENT Syntax

13.1.13 CREATE INDEX Syntax »

Section Navigation [Toggle]

13.1 Data Definition Statements
13.1.1 ALTER DATABASE Syntax
13.1.2 ALTER EVENT Syntax
13.1.3 ALTER LOGFILE GROUP Syntax
13.1.4 ALTER FUNCTION Syntax
13.1.5 ALTER PROCEDURE Syntax
13.1.6 ALTER SERVER Syntax
13.1.7 ALTER TABLE Syntax
13.1.8 ALTER TABLESPACE Syntax
13.1.9 ALTER VIEW Syntax
13.1.10 CREATE DATABASE Syntax
13.1.11 CREATE EVENT Syntax
13.1.12 CREATE FUNCTION Syntax
13.1.13 CREATE INDEX Syntax
13.1.14 CREATE LOGFILE GROUP Syntax
13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
13.1.16 CREATE SERVER Syntax
13.1.17 CREATE TABLE Syntax
13.1.18 CREATE TABLESPACE Syntax
13.1.19 CREATE TRIGGER Syntax
13.1.20 CREATE VIEW Syntax
13.1.21 DROP DATABASE Syntax
13.1.22 DROP EVENT Syntax
13.1.23 DROP FUNCTION Syntax
13.1.24 DROP INDEX Syntax
13.1.25 DROP LOGFILE GROUP Syntax
13.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
13.1.27 DROP SERVER Syntax
13.1.28 DROP TABLE Syntax
13.1.29 DROP TABLESPACE Syntax
13.1.30 DROP TRIGGER Syntax
13.1.31 DROP VIEW Syntax
13.1.32 RENAME TABLE Syntax
13.1.33 TRUNCATE TABLE Syntax

13.1.12 `CREATE FUNCTION` Syntax

The CREATE FUNCTION statement is used to create stored functions and user-defined functions (UDFs):

For information about creating stored functions, see Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”.
For information about creating user-defined functions, see Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”.

Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

Developer Zone
Documentation
Developer Articles
Forums
Lists
Bugs
Worklog
Planet MySQL
Labs

Downloads
MySQL Community Server
MySQL Proxy
MySQL Cluster
MySQL Workbench
MySQL Connectors
Archives

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster
Other Documents
About
Archives

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2014, Oracle Corporation and/or its affiliates