無料PHPプログラム

MySQL 5.1 リファレンスマニュアル :: 25 Extending MySQL :: 25.3 Adding New Functions to MySQL :: 25.3.1 Features of the User-Defined Function Interface
« 25.3 Adding New Functions to MySQL

25.3.2 CREATE FUNCTION Syntax »
Section Navigation      [Toggle]
  • 25.3 Adding New Functions to MySQL
  • 25.3.1 Features of the User-Defined Function Interface
  • 25.3.2 CREATE FUNCTION Syntax
  • 25.3.3 DROP FUNCTION Syntax
  • 25.3.4 Adding a New User-Defined Function
  • 25.3.5 Adding a New Native Function

25.3.1. Features of the User-Defined Function Interface

The MySQL interface for user-defined functions provides the following features and capabilities:

  • Functions can return string, integer, or real values.

  • You can define simple functions that operate on a single row at a time, or aggregate functions that operate on groups of rows.

  • Information is provided to functions that enables them to check the number and types of the arguments passed to them.

  • You can tell MySQL to coerce arguments to a given type before passing them to a function.

  • You can indicate that a function returns NULL or that an error occurred.

Copyright c 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Top / Previous / Next / Up / Table of Contents
© 2010, Oracle Corporation and/or its affiliates

無料CGI PHPスクリプト | 新着情報スクリプト | 営業日カレンダー | PHPマニュアル | MySQLマニュアル | PEARマニュアル

Copyright (c) 2010 jmcodex.com All rights reserved.