<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    626 MySQL Technical Reference for Version 4.0.3    The String *str argument provides a string bu er that may be used to hold the result. (For more information about the String type, take a look at the `sql_string.h' le.)    The  ::str()  function should return the string that holds the result or  (char*) 0  if the result is NULL.    All current string functions try to avoid allocating any memory unless absolutely nec- essary! 9.3  Adding New Procedures to MySQL In MySQL, you can de ne a procedure in C++ that can access and modify the data in a query before it is sent to the client.  The modi cation can be done on row-by-row or GROUP BY  level. We have created an example procedure in MySQL Version 3.23 to show you what can be done. Additionally we recommend you to take a look at mylua.  With this you can use the LUA language to load a procedure at runtime into mysqld. 9.3.1  Procedure Analyse analyse([max elements,[max memory]]) This procedure is de ned in the `sql/sql_analyse.cc'. This examines the result from your query and returns an analysis of the results:    max elements  (default 256) is the maximum number of distinct values  analyse  will notice per column.  This is used by analyse to check if the optimal column type should be of type ENUM.    max memory  (default 8192) is the maximum memory  analyse  should allocate per col- umn while trying to nd all distinct values. SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([max elements,[max 9.3.2  Writing a Procedure For the moment, the only documentation for this is the source. You can nd all information about procedures by examining the following les:    `sql/sql_analyse.cc'    `sql/procedure.h'    `sql/procedure.cc'    `sql/sql_select.cc'
     

    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
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide