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
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

    SpiritHost - web hosting for spiritual and education sites
    SpiritHit.com - Religious and Spiritual Portal

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • Return to Table of Contents
    		•
  • Back to top