<< 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
    558 MySQL Technical Reference for Version 4.0.3 Flag value Flag description NOT_NULL_FLAG Field can't be NULL PRI_KEY_FLAG Field is part of a primary key UNIQUE_KEY_FLAG Field is part of a unique key MULTIPLE_KEY_FLAG Field is part of a non-unique key UNSIGNED_FLAG Field has the UNSIGNED attribute ZEROFILL_FLAG Field has the ZEROFILL attribute BINARY_FLAG Field has the BINARY attribute AUTO_INCREMENT_FLAG Field has the AUTO_INCREMENT attribute ENUM_FLAG Field is an ENUM (deprecated) SET_FLAG Field is a SET (deprecated) BLOB_FLAG Field is a BLOB or TEXT (deprecated) TIMESTAMP_FLAG Field is a TIMESTAMP (deprecated) Use  of  the  BLOB_FLAG,  ENUM_FLAG,  SET_FLAG,  and  TIMESTAMP_FLAG   ags  is deprecated because they indicate the type of a eld rather than an attribute of  its  type.   It  is  preferable  to  test  field->type  against  FIELD_TYPE_BLOB, FIELD_TYPE_ENUM,  FIELD_TYPE_SET, or  FIELD_TYPE_TIMESTAMP  instead. The following example illustrates a typical use of the flags value: if (field->flags & NOT_NULL_FLAG) printf("Field can't be null\n"); You may use the following convenience macros to determine the boolean status of the flags value: Flag status Description IS_NOT_NULL(flags) True if this eld is de ned as NOT NULL IS_PRI_KEY(flags) True if this eld is a primary key IS_BLOB(flags) True if this eld is a BLOB or TEXT (deprecated; test field->type instead) unsigned int decimals The number of decimals for numeric elds. 8.4.2  C API Function Overview The functions available in the C API are listed here and are described in greater detail in a later section.  See Section 8.4.3 [C API functions], page 562. Function Description mysql  a ected  rows() Returns  the  number  of  rows  changed/deleted/inserted  by the last UPDATE, DELETE, or INSERT query. mysql  change  user() Changes user and database on an open connection. mysql  character  set  name() Returns the name of the default character set for the con- nection. mysql  close() Closes a server connection.
     

    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