9 Extending MySQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613

       9.1 MySQL Internals. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613
              9.1.1 MySQL Threads. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .613
              9.1.2 MySQL Test Suite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .613
              9.1.2.1 Running the MySQL Test Suite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 614
              9.1.2.2 Extending the MySQL Test Suite . . . . . . . . . . . . . . . . . . . . . . . . . . . . 614
              9.1.2.3 Reporting Bugs in the MySQL Test Suite . . . . . . . . . . . . . . . . . . . . .615

       9.2 Adding New Functions to MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .616
              9.2.1 CREATE FUNCTION/DROP FUNCTION Syntax. . . . . . . . . . . . . . . . . 617
              9.2.2 Adding a New User-de nable Function . . . . . . . . . . . . . . . . . . . . . . . . 617
              9.2.2.1 UDF Calling Sequences for simple functions . . . . . . . . . . . . . . . . 619
              9.2.2.2 UDF Calling Sequences for aggregate functions . . . . . . . . . . . . . 620
              9.2.2.3 Argument Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 621
              9.2.2.4 Return Values and Error Handling . . . . . . . . . . . . . . . . . . . . . . . . . . 622
              9.2.2.5 Compiling and Installing User-de nable Functions . . . . . . . . . . . 623
              9.2.3 Adding a New Native Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .624

       9.3 Adding New Procedures to MySQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .626
              9.3.1 Procedure Analyse. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 626
              9.3.2 Writing a Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .626
| | | | | | | |
  • Return to Table of Contents
    •  

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top