<< 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
    556 MySQL Technical Reference for Version 4.0.3 The MySQL server shrinks each communication bu er to net_buffer_length bytes after each query.  For clients, the size of the bu er associated with a connection is not decreased until the connection is closed, at which time client memory is reclaimed. For programming with threads, see Section 8.4.8 [Threaded clients], page 604.  For creating a  stand-alone  application  which  includes  the  "server"  and  "client"  in  the  same  program (and does not communicate with an external MySQL server), see Section 8.4.9 [libmysqld], page 605. 8.4.1  C API Datatypes MYSQL This structure represents a handle to one database connection.  It is used for almost all MySQL functions. MYSQL_RES This structure represents the result of a query that returns rows (SELECT, SHOW, DESCRIBE, EXPLAIN). The information returned from a query is called the result set  in the remainder of this section. MYSQL_ROW This is a type-safe representation of one row of data. It is currently implemented as an array of counted byte strings.  (You cannot treat these as null-terminated strings if eld values may contain binary data, because such values may contain null bytes internally.)  Rows are obtained by calling mysql_fetch_row(). MYSQL_FIELD This  structure  contains  information  about  a   eld,  such  as  the   eld's  name, type, and size.  Its members are described in more detail here.  You may obtain the  MYSQL_FIELD  structures  for  each   eld  by  calling  mysql_fetch_field() repeatedly.  Field values are not part of this structure; they are contained in a MYSQL_ROW  structure. MYSQL_FIELD_OFFSET This is a type-safe representation of an o set into a MySQL eld list.  (Used by  mysql_field_seek().)  O sets are eld numbers within a row, beginning at zero. my_ulonglong The type used for the number of rows and for mysql_affected_rows(), mysql_ num_rows(),  and  mysql_insert_id().   This  type  provides  a  range  of  0  to 1.84e19. On some systems, attempting to print a value of type my_ulonglong will not work.  To print such a value, convert it to unsigned long and use a %lu print format.  Example: printf (Number of rows: %lu\n", (unsigned long) mysql_num_ The MYSQL_FIELD structure contains the members listed here: char * name The name of the eld, as a null-terminated string.
     

    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