آژانس هواپیمایی

مشکل با mysql

شروع موضوع توسط digitak ‏25 ژوئن 2007 در انجمن SQL Server

  1. digitak

    digitak Registered User

    تاریخ عضویت:
    ‏25 ژوئن 2007
    نوشته ها:
    133
    تشکر شده:
    7
    می خام بدونم چطوری میشه وقی اطلاعات رو می خوتم توی mysql ارسال (insert) کنم

    اطلاعاتم بیاد روی اولین سطر ذخیره بشه (سطر 0)

    تشکر
     
  2. Admiral-sale-13

    Admiral-sale-13 کاربر تازه وارد

    تاریخ عضویت:
    ‏19 جولای 2006
    نوشته ها:
    68
    تشکر شده:
    0
    MySQL 3.23, 4.0, 4.1 Reference Manual

    http://dev.mysql.com/doc/refman/4.1/en/index.html

    Preface
    1. General Information
    1.1. About This Manual
    1.2. Conventions Used in This Manual
    1.3. Overview of MySQL AB
    1.4. Overview of the MySQL Database Management System
    1.4.1. What is MySQL?
    1.4.2. History of MySQL
    1.4.3. The Main Features of MySQL
    1.5. Overview of the MaxDB Database Management System
    1.5.1. What is MaxDB?
    1.5.2. History of MaxDB
    1.5.3. Features of MaxDB
    1.5.4. Licensing and Support
    1.5.5. Feature Differences Between MaxDB and MySQL
    1.5.6. Interoperability Features Between MaxDB and MySQL
    1.5.7. MaxDB-Related Links
    1.6. MySQL Development Roadmap
    1.6.1. MySQL 4.0 in a Nutshell
    1.6.2. MySQL 4.1 in a Nutshell
    1.6.3. What's New in MySQL 5.0
    1.7. MySQL Information Sources
    1.7.1. MySQL Mailing Lists
    1.7.2. MySQL Community Support at the MySQL Forums
    1.7.3. MySQL Community Support on Internet Relay Chat (IRC)
    1.7.4. MySQL Enterprise
    1.8. How to Report Bugs or Problems
    1.9. MySQL Standards Compliance
    1.9.1. What Standards MySQL Follows
    1.9.2. Selecting SQL Modes
    1.9.3. Running MySQL in ANSI Mode
    1.9.4. MySQL Extensions to Standard SQL
    1.9.5. MySQL Differences from Standard SQL
    1.9.6. How MySQL Deals with Constraints
    2. Installing and Upgrading MySQL
    2.1. General Installation Issues
    2.1.1. Operating Systems On Which MySQL Is Known To Run
    2.1.2. Choosing Which MySQL Distribution to Install
    2.1.3. How to Get MySQL
    2.1.4. Verifying Package Integrity Using MD5 Checksums or GnuPG
    2.1.5. Installation Layouts
    2.2. Standard MySQL Installation Using a Binary Distribution
    2.3. Installing MySQL on Windows
    2.3.1. Choosing An Installation Package
    2.3.2. Installing MySQL with the Automated Installer
    2.3.3. Using the MySQL Installation Wizard
    2.3.4. Using the Configuration Wizard
    2.3.5. Installing MySQL from a Noinstall Zip Archive
    2.3.6. Extracting the Install Archive
    2.3.7. Creating an Option File
    2.3.8. Selecting a MySQL Server Type
    2.3.9. Starting the Server for the First Time
    2.3.10. Starting MySQL from the Windows Command Line
    2.3.11. Starting MySQL as a Windows Service
    2.3.12. Testing The MySQL Installation
    2.3.13. Troubleshooting a MySQL Installation Under Windows
    2.3.14. Upgrading MySQL on Windows
    2.3.15. MySQL on Windows Compared to MySQL on Unix
    2.4. Installing MySQL from RPM Packages on Linux
    2.5. Installing MySQL on Mac OS X
    2.6. Installing MySQL on Solaris
    2.7. Installing MySQL on NetWare
    2.8. Installing MySQL from tar.gz Packages on Other Unix-Like Systems
    2.9. MySQL Installation Using a Source Distribution
    2.9.1. Source Installation Overview
    2.9.2. Typical configure Options
    2.9.3. Installing from the Development Source Tree
    2.9.4. Dealing with Problems Compiling MySQL
    2.9.5. MIT-pthreads Notes
    2.9.6. Installing MySQL from Source on Windows
    2.9.7. Compiling MySQL Clients on Windows
    2.10. Post-Installation Setup and Testing
    2.10.1. Windows Post-Installation Procedures
    2.10.2. Unix Post-Installation Procedures
    2.10.3. Securing the Initial MySQL Accounts
    2.11. Upgrading MySQL
    2.11.1. Upgrading from MySQL 4.0 to 4.1
    2.11.2. Upgrading from MySQL 3.23 to 4.0
    2.11.3. Copying MySQL Databases to Another Machine
    2.12. Downgrading MySQL
    2.12.1. Downgrading to MySQL 4.0
    2.13. Operating System-Specific Notes
    2.13.1. Linux Notes
    2.13.2. Mac OS X Notes
    2.13.3. Solaris Notes
    2.13.4. BSD Notes
    2.13.5. Other Unix Notes
    2.13.6. OS/2 Notes
    2.14. Environment Variables
    2.15. Perl Installation Notes
    2.15.1. Installing Perl on Unix
    2.15.2. Installing ActiveState Perl on Windows
    2.15.3. Problems Using the Perl DBI/DBD Interface
    3. Tutorial
    3.1. Connecting to and Disconnecting from the Server
    3.2. Entering Queries
    3.3. Creating and Using a Database
    3.3.1. Creating and Selecting a Database
    3.3.2. Creating a Table
    3.3.3. Loading Data into a Table
    3.3.4. Retrieving Information from a Table
    3.4. Getting Information About Databases and Tables
    3.5. Using mysql in Batch Mode
    3.6. Examples of Common Queries
    3.6.1. The Maximum Value for a Column
    3.6.2. The Row Holding the Maximum of a Certain Column
    3.6.3. Maximum of Column per Group
    3.6.4. The Rows Holding the Group-wise Maximum of a Certain Field
    3.6.5. Using User-Defined Variables
    3.6.6. Using Foreign Keys
    3.6.7. Searching on Two Keys
    3.6.8. Calculating Visits Per Day
    3.6.9. Using AUTO_INCREMENT
    3.7. Queries from the Twin Project
    3.7.1. Find All Non-distributed Twins
    3.7.2. Show a Table of Twin Pair Status
    3.8. Using MySQL with Apache
    4. Using MySQL Programs
    4.1. Overview of MySQL Programs
    4.2. Invoking MySQL Programs
    4.3. Specifying Program Options
    4.3.1. Using Options on the Command Line
    4.3.2. Using Option Files
    4.3.3. Using Environment Variables to Specify Options
    4.3.4. Using Options to Set Program Variables
    5. Database Administration
    5.1. Overview of Server-Side Programs
    5.2. mysqld — The MySQL Server
    5.2.1. Option and Variable Reference
    5.2.2. Command Options
    5.2.3. System Variables
    5.2.4. Using System Variables
    5.2.5. Status Variables
    5.2.6. SQL Modes
    5.2.7. The Shutdown Process
    5.2.8. Server-Side Help
    5.3. The mysqld-max Extended MySQL Server
    5.4. MySQL Server Startup Programs
    5.4.1. mysqld_safe — MySQL Server Startup Script
    5.4.2. mysql.server — MySQL Server Startup Script
    5.4.3. mysqld_multi — Manage Multiple MySQL Servers
    5.5. Installation-Related Programs
    5.5.1. comp_err — Compile MySQL Error Message File
    5.5.2. make_win_src_distribution — Create Source Distribution for Windows
    5.5.3. mysql_create_system_tables — Generate Statements to Initialize MySQL System Tables
    5.5.4. mysql_fix_privilege_tables — Upgrade MySQL System Tables
    5.5.5. mysql_install_db — MySQL Data Directory Initialization Script
    5.5.6. mysql_secure_installation — Improve MySQL Installation Security
    5.5.7. mysql_tzinfo_to_sql — Load the Time Zone Tables
    5.6. General Security Issues
    5.6.1. General Security Guidelines
    5.6.2. Making MySQL Secure Against Attackers
    5.6.3. Security-Related mysqld Options
    5.6.4. Security Issues with LOAD DATA LOCAL
    5.6.5. How to Run MySQL as a Normal User
    5.7. The MySQL Access Privilege System
    5.7.1. What the Privilege System Does
    5.7.2. How the Privilege System Works
    5.7.3. Privileges Provided by MySQL
    5.7.4. Connecting to the MySQL Server
    5.7.5. Access Control, Stage 1: Connection Verification
    5.7.6. Access Control, Stage 2: Request Verification
    5.7.7. When Privilege Changes Take Effect
    5.7.8. Causes of Access denied Errors
    5.7.9. Password Hashing as of MySQL 4.1
    5.8. MySQL User Account Management
    5.8.1. MySQL Usernames and Passwords
    5.8.2. Adding New User Accounts to MySQL
    5.8.3. Removing User Accounts from MySQL
    5.8.4. Limiting Account Resources
    5.8.5. Assigning Account Passwords
    5.8.6. Keeping Your Password Secure
    5.8.7. Using Secure Connections
    5.9. Backup and Recovery
    5.9.1. Database Backups
    5.9.2. Example Backup and Recovery Strategy
    5.9.3. Point-in-Time Recovery
    5.9.4. Table Maintenance and Crash Recovery
    5.10. MySQL Localization and International Usage
    5.10.1. The Character Set Used for Data and Sorting
    5.10.2. Setting the Error Message Language
    5.10.3. Adding a New Character Set
    5.10.4. The Character Definition Arrays
    5.10.5. String Collating Support
    5.10.6. Multi-Byte Character Support
    5.10.7. Problems With Character Sets
    5.10.8. MySQL Server Time Zone Support
    5.10.9. MySQL Server Locale Support
    5.11. MySQL Server Logs
    5.11.1. The Error Log
    5.11.2. The General Query Log
    5.11.3. The Update Log
    5.11.4. The Binary Log
    5.11.5. The Slow Query Log
    5.11.6. Server Log Maintenance
    5.12. Running Multiple MySQL Servers on the Same Machine
    5.12.1. Running Multiple Servers on Windows
    5.12.2. Running Multiple Servers on Unix
    5.12.3. Using Client Programs in a Multiple-Server Environment
    6. Replication
    6.1. Introduction to Replication
    6.2. Replication Implementation Overview
    6.3. Replication Implementation Details
    6.3.1. Replication Master Thread States
    6.3.2. Replication Slave I/O Thread States
    6.3.3. Replication Slave SQL Thread States
    6.3.4. Replication Slave Connection Thread States
    6.3.5. Replication Relay and Status Files
    6.4. How to Set Up Replication
    6.5. Replication Compatibility Between MySQL Versions
    6.6. Upgrading a Replication Setup
    6.6.1. Upgrading Replication to 4.0 or 4.1
    6.7. Replication Features and Known Problems
    6.8. Replication Startup Options
    6.9. How Servers Evaluate Replication Rules
    6.10. Replication FAQ
    6.11. Troubleshooting Replication
    6.12. How to Report Replication Bugs or Problems
    7. Optimization
    7.1. Optimization Overview
    7.1.1. MySQL Design Limitations and Tradeoffs
    7.1.2. Designing Applications for Portability
    7.1.3. What We Have Used MySQL For
    7.1.4. The MySQL Benchmark Suite
    7.1.5. Using Your Own Benchmarks
    7.2. Optimizing SELECT and Other Statements
    7.2.1. Optimizing Queries with EXPLAIN
    7.2.2. Estimating Query Performance
    7.2.3. Speed of SELECT Queries
    7.2.4. WHERE Clause Optimization
    7.2.5. Range Optimization
    7.2.6. IS NULL Optimization
    7.2.7. LEFT JOIN and RIGHT JOIN Optimization
    7.2.8. ORDER BY Optimization
    7.2.9. GROUP BY Optimization
    7.2.10. DISTINCT Optimization
    7.2.11. LIMIT Optimization
    7.2.12. How to Avoid Table Scans
    7.2.13. Speed of INSERT Statements
    7.2.14. Speed of UPDATE Statements
    7.2.15. Speed of DELETE Statements
    7.2.16. Other Optimization Tips
    7.3. Locking Issues
    7.3.1. Internal Locking Methods
    7.3.2. Table Locking Issues
    7.3.3. Concurrent Inserts
    7.3.4. External Locking
    7.4. Optimizing Database Structure
    7.4.1. Design Choices
    7.4.2. Make Your Data as Small as Possible
    7.4.3. Column Indexes
    7.4.4. Multiple-Column Indexes
    7.4.5. How MySQL Uses Indexes
    7.4.6. The MyISAM Key Cache
    7.4.7. MyISAM Index Statistics Collection
    7.4.8. How MySQL Opens and Closes Tables
    7.4.9. Drawbacks to Creating Many Tables in the Same Database
    7.5. Optimizing the MySQL Server
    7.5.1. System Factors and Startup Parameter Tuning
    7.5.2. Tuning Server Parameters
    7.5.3. The MySQL Query Cache
    7.5.4. Examining Thread Information
    7.5.5. How Compiling and Linking Affects the Speed of MySQL
    7.5.6. How MySQL Uses Memory
    7.5.7. How MySQL Uses Internal Temporary Tables
    7.5.8. How MySQL Uses DNS
    7.6. Disk Issues
    7.6.1. Using Symbolic Links
    8. Client and Utility Programs
    8.1. Overview of Client and Utility Programs
    8.2. my_print_defaults — Display Options from Option Files
    8.3. myisam_ftdump — Display Full-Text Index information
    8.4. myisamchk — MyISAM Table-Maintenance Utility
    8.4.1. myisamchk General Options
    8.4.2. myisamchk Check Options
    8.4.3. myisamchk Repair Options
    8.4.4. Other myisamchk Options
    8.4.5. myisamchk Memory Usage
    8.5. myisamlog — Display MyISAM Log File Contents
    8.6. myisampack — Generate Compressed, Read-Only MyISAM Tables
    8.7. mysql — The MySQL Command-Line Tool
    8.7.1. mysql Options
    8.7.2. mysql Commands
    8.7.3. mysql Server-Side Help
    8.7.4. Executing SQL Statements from a Text File
    8.7.5. mysql Tips
    8.8. mysqlaccess — Client for Checking Access Privileges
    8.9. mysqladmin — Client for Administering a MySQL Server
    8.10. mysqlbinlog — Utility for Processing Binary Log Files
    8.11. mysqlcheck — A Table Maintenance and Repair Program
    8.12. mysqldump — A Database Backup Program
    8.13. mysqlhotcopy — A Database Backup Program
    8.14. mysqlimport — A Data Import Program
    8.15. mysqlmanagerc — Internal Test-Suite Program
    8.16. mysqlmanager-pwgen — Internal Test-Suite Program
    8.17. mysqlshow — Display Database, Table, and Column Information
    8.18. mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
    8.19. mysql_explain_log — Use EXPLAIN on Statements in Query Log
    8.20. mysql_find_rows — Extract Queries from Update Log
    8.21. mysql_fix_extensions — Make Table Filename Extensions Lowercase
    8.22. mysql_setpermission — Interactively Set Permissions in Grant Tables
    8.23. mysql_tableinfo — Generate Database Metadata
    8.24. mysql_waitpid — Kill Process and Wait for Its Termination
    8.25. mysql_zap — Kill Processes That Match a Pattern
    8.26. perror — Explain Error Codes
    8.27. replace — A String-Replacement Utility
    8.28. resolveip — Resolve Hostname to IP Address or Vice Versa
    8.29. resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
    9. Language Structure
    9.1. Literal Values
    9.1.1. Strings
    9.1.2. Numbers
    9.1.3. Hexadecimal Values
    9.1.4. Boolean Values
    9.1.5. NULL Values
    9.2. Database, Table, Index, Column, and Alias Names
    9.2.1. Identifier Qualifiers
    9.2.2. Identifier Case Sensitivity
    9.2.3. Function Name Parsing and Resolution
    9.3. Reserved Words
    9.4. User-Defined Variables
    9.5. Comment Syntax
    10. Character Set Support
    10.1. Character Sets and Collations in General
    10.2. Character Sets and Collations in MySQL
    10.3. Specifying Character Sets and Collations
    10.3.1. Server Character Set and Collation
    10.3.2. Database Character Set and Collation
    10.3.3. Table Character Set and Collation
    10.3.4. Column Character Set and Collation
    10.3.5. Character String Literal Character Set and Collation
    10.3.6. National Character Set
    10.3.7. Examples of Character Set and Collation Assignment
    10.3.8. Compatibility with Other DBMSs
    10.4. Connection Character Sets and Collations
    10.5. Collation Issues
    10.5.1. Using COLLATE in SQL Statements
    10.5.2. COLLATE Clause Precedence
    10.5.3. BINARY Operator
    10.5.4. Some Special Cases Where the Collation Determination Is Tricky
    10.5.5. Collations Must Be for the Right Character Set
    10.5.6. An Example of the Effect of Collation
    10.6. Operations Affected by Character Set Support
    10.6.1. Result Strings
    10.6.2. CONVERT() and CAST()
    10.6.3. SHOW Statements and INFORMATION_SCHEMA
    10.7. Unicode Support
    10.8. UTF-8 for Metadata
    10.9. Upgrading Character Sets from MySQL 4.0
    10.9.1. 4.0 Character Sets and Corresponding 4.1 Character Set/Collation Pairs
    10.9.2. Converting 4.0 Character Columns to 4.1 Format
    10.10. Character Sets and Collations That MySQL Supports
    10.10.1. Unicode Character Sets
    10.10.2. West European Character Sets
    10.10.3. Central European Character Sets
    10.10.4. South European and Middle East Character Sets
    10.10.5. Baltic Character Sets
    10.10.6. Cyrillic Character Sets
    10.10.7. Asian Character Sets
    11. Data Types
    11.1. Data Type Overview
    11.1.1. Overview of Numeric Types
    11.1.2. Overview of Date and Time Types
    11.1.3. Overview of String Types
    11.1.4. Data Type Default Values
    11.2. Numeric Types
    11.3. Date and Time Types
    11.3.1. The DATETIME, DATE, and TIMESTAMP Types
    11.3.2. The TIME Type
    11.3.3. The YEAR Type
    11.3.4. Year 2000 Issues and Date Types
    11.4. String Types
    11.4.1. The CHAR and VARCHAR Types
    11.4.2. The BINARY and VARBINARY Types
    11.4.3. The BLOB and TEXT Types
    11.4.4. The ENUM Type
    11.4.5. The SET Type
    11.5. Data Type Storage Requirements
    11.6. Choosing the Right Type for a Column
    11.7. Using Data Types from Other Database Engines
    12. Functions and Operators
    12.1. Operator and Function Reference
    12.2. Operators
    12.2.1. Operator Precedence
    12.2.2. Type Conversion in Expression Evaluation
    12.2.3. Comparison Functions and Operators
    12.2.4. Logical Operators
    12.3. Control Flow Functions
    12.4. String Functions
    12.4.1. String Comparison Functions
    12.4.2. Regular Expressions
    12.5. Numeric Functions
    12.5.1. Arithmetic Operators
    12.5.2. Mathematical Functions
    12.6. Date and Time Functions
    12.7. What Calendar Is Used By MySQL?
    12.8. Full-Text Search Functions
    12.8.1. Boolean Full-Text Searches
    12.8.2. Full-Text Searches with Query Expansion
    12.8.3. Full-Text Stopwords
    12.8.4. Full-Text Restrictions
    12.8.5. Fine-Tuning MySQL Full-Text Search
    12.9. Cast Functions and Operators
    12.10. Other Functions
    12.10.1. Bit Functions
    12.10.2. Encryption and Compression Functions
    12.10.3. Information Functions
    12.10.4. Miscellaneous Functions
    12.11. Functions and Modifiers for Use with GROUP BY Clauses
    12.11.1. GROUP BY (Aggregate) Functions
    12.11.2. GROUP BY Modifiers
    12.11.3. GROUP BY and HAVING with Hidden Fields
    13. SQL Statement Syntax
    13.1. Data Definition Statements
    13.1.1. ALTER DATABASE Syntax
    13.1.2. ALTER TABLE Syntax
    13.1.3. CREATE DATABASE Syntax
    13.1.4. CREATE INDEX Syntax
    13.1.5. CREATE TABLE Syntax
    13.1.6. DROP DATABASE Syntax
    13.1.7. DROP INDEX Syntax
    13.1.8. DROP TABLE Syntax
    13.1.9. RENAME TABLE Syntax
    13.2. Data Manipulation Statements
    13.2.1. DELETE Syntax
    13.2.2. DO Syntax
    13.2.3. HANDLER Syntax
    13.2.4. INSERT Syntax
    13.2.5. LOAD DATA INFILE Syntax
    13.2.6. REPLACE Syntax
    13.2.7. SELECT Syntax
    13.2.8. Subquery Syntax
    13.2.9. TRUNCATE Syntax
    13.2.10. UPDATE Syntax
    13.3. MySQL Utility Statements
    13.3.1. DESCRIBE Syntax
    13.3.2. HELP Syntax
    13.3.3. USE Syntax
    13.4. MySQL Transactional and Locking Statements
    13.4.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax
    13.4.2. Statements That Cannot Be Rolled Back
    13.4.3. Statements That Cause an Implicit Commit
    13.4.4. SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
    13.4.5. LOCK TABLES and UNLOCK TABLES Syntax
    13.4.6. SET TRANSACTION Syntax
    13.5. Database Administration Statements
    13.5.1. Account Management Statements
    13.5.2. Table Maintenance Statements
    13.5.3. SET Syntax
    13.5.4. SHOW Syntax
    13.5.5. Other Administrative Statements
    13.6. Replication Statements
    13.6.1. SQL Statements for Controlling Master Servers
    13.6.2. SQL Statements for Controlling Slave Servers
    13.7. SQL Syntax for Prepared Statements
    14. Storage Engines
    14.1. The MyISAM Storage Engine
    14.1.1. MyISAM Startup Options
    14.1.2. Space Needed for Keys
    14.1.3. MyISAM Table Storage Formats
    14.1.4. MyISAM Table Problems
    14.2. The InnoDB Storage Engine
    14.2.1. InnoDB Overview
    14.2.2. InnoDB Contact Information
    14.2.3. InnoDB in MySQL 3.23
    14.2.4. InnoDB Configuration
    14.2.5. InnoDB Startup Options and System Variables
    14.2.6. Creating the InnoDB Tablespace
    14.2.7. Creating and Using InnoDB Tables
    14.2.8. Adding and Removing InnoDB Data and Log Files
    14.2.9. Backing Up and Recovering an InnoDB Database
    14.2.10. Moving an InnoDB Database to Another Machine
    14.2.11. InnoDB Transaction Model and Locking
    14.2.12. InnoDB Performance Tuning Tips
    14.2.13. Implementation of Multi-Versioning
    14.2.14. InnoDB Table and Index Structures
    14.2.15. InnoDB File Space Management and Disk I/O
    14.2.16. InnoDB Error Handling
    14.2.17. Restrictions on InnoDB Tables
    14.2.18. InnoDB Troubleshooting
    14.3. The MERGE Storage Engine
    14.3.1. MERGE Table Problems
    14.4. The MEMORY (HEAP) Storage Engine
    14.5. The BDB (BerkeleyDB) Storage Engine
    14.5.1. Operating Systems Supported by BDB
    14.5.2. Installing BDB
    14.5.3. BDB Startup Options
    14.5.4. Characteristics of BDB Tables
    14.5.5. Restrictions on BDB Tables
    14.5.6. Errors That May Occur When Using BDB Tables
    14.6. The EXAMPLE Storage Engine
    14.7. The ARCHIVE Storage Engine
    14.8. The CSV Storage Engine
    14.9. The BLACKHOLE Storage Engine
    14.10. The ISAM Storage Engine
    15. MySQL Cluster
    15.1. MySQL Cluster Overview
    15.1.1. MySQL Cluster Core Concepts
    15.1.2. MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
    15.2. Simple Multi-Computer How-To
    15.2.1. Hardware, Software, and Networking
    15.2.2. Multi-Computer Installation
    15.2.3. Multi-Computer Configuration
    15.2.4. Initial Startup
    15.2.5. Loading Sample Data and Performing Queries
    15.2.6. Safe Shutdown and Restart
    15.3. MySQL Cluster Configuration
    15.3.1. Building MySQL Cluster from Source Code
    15.3.2. Installing the Software
    15.3.3. Quick Test Setup of MySQL Cluster
    15.3.4. Configuration File
    15.3.5. Overview of Cluster Configuration Parameters
    15.3.6. Configuring Parameters for Local Checkpoints
    15.4. Upgrading and Downgrading MySQL Cluster
    15.4.1. Performing a Rolling Restart of the Cluster
    15.4.2. Cluster Upgrade and Downgrade Compatibility
    15.5. Process Management in MySQL Cluster
    15.5.1. MySQL Server Process Usage for MySQL Cluster
    15.5.2. ndbd — The Storage Engine Node Process
    15.5.3. ndb_mgmd — The Management Server Process
    15.5.4. ndb_mgm — The Management Client Process
    15.5.5. Command Options for MySQL Cluster Processes
    15.6. Management of MySQL Cluster
    15.6.1. Summary of MySQL Cluster Start Phases
    15.6.2. Commands in the MySQL Cluster Management Client
    15.6.3. Event Reports Generated in MySQL Cluster
    15.6.4. Single User Mode
    15.6.5. Quick Reference: MySQL Cluster SQL Statements
    15.7. On-line Backup of MySQL Cluster
    15.7.1. Cluster Backup Concepts
    15.7.2. Using The Management Client to Create a Backup
    15.7.3. ndb_restore — Restore a Cluster Backup
    15.7.4. Configuration for Cluster Backup
    15.7.5. Backup Troubleshooting
    15.8. Cluster Utility Programs
    15.8.1. ndb_config — Extract NDB Configuration Information
    15.8.2. ndb_cpcd — Automate Testing for NDB Development
    15.8.3. ndb_delete_all — Delete All Rows from NDB Table
    15.8.4. ndb_desc — Describe NDB Tables
    15.8.5. ndb_drop_index — Drop Index from NDB Table
    15.8.6. ndb_drop_table — Drop NDB Table
    15.8.7. ndb_error_reporter — NDB Error-Reporting Utility
    15.8.8. ndb_print_backup_file — Print NDB Backup File Contents
    15.8.9. ndb_print_schema_file — Print NDB Schema File Contents
    15.8.10. ndb_print_sys_file — Print NDB System File Contents
    15.8.11. ndb_select_all — Print Rows from NDB Table
    15.8.12. ndb_select_count — Print Row Counts for NDB Tables
    15.8.13. ndb_show_tables — Display List of NDB Tables
    15.8.14. ndb_size.pl — NDBCluster Size Requirement Estimator
    15.8.15. ndb_waiter — Wait for Cluster to Reach a Given Status
    15.9. Using High-Speed Interconnects with MySQL Cluster
    15.9.1. Configuring MySQL Cluster to use SCI Sockets
    15.9.2. Understanding the Impact of Cluster Interconnects
    15.10. Known Limitations of MySQL Cluster
    15.10.1. Non-Compliance In SQL Syntax
    15.10.2. Limits and Differences from Standard MySQL Limits
    15.10.3. Limits Relating to Transaction Handling
    15.10.4. Error Handling
    15.10.5. Limits Associated with Database Objects
    15.10.6. Unsupported Or Missing Features
    15.10.7. Limitations Relating to Performance
    15.10.8. Issues Exclusive to MySQL Cluster
    15.10.9. Limitations Relating to Multiple Cluster Nodes
    15.11. MySQL Cluster FAQ
    15.12. MySQL Cluster Glossary
    16. Spatial Extensions
    16.1. Introduction to MySQL Spatial Support
    16.2. The OpenGIS Geometry Model
    16.2.1. The Geometry Class Hierarchy
    16.2.2. Class Geometry
    16.2.3. Class Point
    16.2.4. Class Curve
    16.2.5. Class LineString
    16.2.6. Class Surface
    16.2.7. Class Polygon
    16.2.8. Class GeometryCollection
    16.2.9. Class MultiPoint
    16.2.10. Class MultiCurve
    16.2.11. Class MultiLineString
    16.2.12. Class MultiSurface
    16.2.13. Class MultiPolygon
    16.3. Supported Spatial Data Formats
    16.3.1. Well-Known Text (WKT) Format
    16.3.2. Well-Known Binary (WKB) Format
    16.4. Creating a Spatially Enabled MySQL Database
    16.4.1. MySQL Spatial Data Types
    16.4.2. Creating Spatial Values
    16.4.3. Creating Spatial Columns
    16.4.4. Populating Spatial Columns
    16.4.5. Fetching Spatial Data
    16.5. Analyzing Spatial Information
    16.5.1. Geometry Format Conversion Functions
    16.5.2. Geometry Functions
    16.5.3. Functions That Create New Geometries from Existing Ones
    16.5.4. Functions for Testing Spatial Relations Between Geometric Objects
    16.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)
    16.5.6. Functions That Test Spatial Relationships Between Geometries
    16.6. Optimizing Spatial Analysis
    16.6.1. Creating Spatial Indexes
    16.6.2. Using a Spatial Index
    16.7. MySQL Conformance and Compatibility
    17. APIs and Libraries
    17.1. libmysqld, the Embedded MySQL Server Library
    17.1.1. Overview of the Embedded MySQL Server Library
    17.1.2. Compiling Programs with libmysqld
    17.1.3. Restrictions When Using the Embedded MySQL Server
    17.1.4. Options with the Embedded Server
    17.1.5. Embedded Server Examples
    17.1.6. Licensing the Embedded Server
    17.2. MySQL C API
    17.2.1. C API Data types
    17.2.2. C API Function Overview
    17.2.3. C API Function Descriptions
    17.2.4. C API Prepared Statements
    17.2.5. C API Prepared Statement Data types
    17.2.6. C API Prepared Statement Function Overview
    17.2.7. C API Prepared Statement Function Descriptions
    17.2.8. C API Prepared statement problems
    17.2.9. C API Handling of Multiple Statement Execution
    17.2.10. C API Handling of Date and Time Values
    17.2.11. C API Threaded Function Descriptions
    17.2.12. C API Embedded Server Function Descriptions
    17.2.13. Controlling Automatic Reconnect Behavior
    17.2.14. Common Questions and Problems When Using the C API
    17.2.15. Building Client Programs
    17.2.16. How to Make a Threaded Client
    17.3. MySQL PHP API
    17.3.1. Common Problems with MySQL and PHP
    17.3.2. Enabling Both mysql and mysqli in PHP
    17.4. MySQL Perl API
    17.5. MySQL C++ API
    17.6. MySQL Python API
    17.7. MySQL Tcl API
    17.8. MySQL Eiffel Wrapper
    17.9. MySQL Program Development Utilities
    17.9.1. msql2mysql — Convert mSQL Programs for Use with MySQL
    17.9.2. mysql_config — Get Compile Options for Compiling Clients
    18. Connectors
    18.1. MySQL Connector/ODBC
    18.1.1. Introduction to Connector/ODBC
    18.1.2. Connector/ODBC Installation
    18.1.3. Connector/ODBC Configuration
    18.1.4. Connector/ODBC Examples
    18.1.5. Connector/ODBC Reference
    18.1.6. Connector/ODBC Notes and Tips
    18.1.7. Connector/ODBC Support
    18.2. MySQL Connector/NET
    18.2.1. Connector/NET Versions
    18.2.2. Connector/NET Installation
    18.2.3. Connector/NET Examples and Usage Guide
    18.2.4. Connector/NET Reference
    18.2.5. Connector/NET Notes and Tips
    18.2.6. Connector/NET Support
    18.3. MySQL Visual Studio Plugin
    18.3.1. Installing the MySQL Visual Studio Plugin
    18.3.2. Creating a connection to the MySQL server
    18.3.3. Using the MySQL Visual Studio Plugin
    18.3.4. Visual Studio Plugin Support
    18.4. MySQL Connector/J
    18.4.1. Connector/J Versions
    18.4.2. Connector/J Installation
    18.4.3. Connector/J Examples
    18.4.4. Connector/J (JDBC) Reference
    18.4.5. Connector/J Notes and Tips
    18.4.6. Connector/J Support
    18.5. MySQL Connector/MXJ
    18.5.1. Introduction to Connector/MXJ
    18.5.2. Connector/MXJ Installation
    18.5.3. Connector/MXJ Configuration
    18.5.4. Connector/MXJ Reference
    18.5.5. Connector/MXJ Notes and Tips
    18.5.6. Connector/MXJ Support
    18.6. Connector/PHP
    19. Extending MySQL
    19.1. MySQL Internals
    19.1.1. MySQL Threads
    19.1.2. MySQL Test Suite
    19.2. Adding New Functions to MySQL
    19.2.1. Features of the User-Defined Function Interface
    19.2.2. CREATE FUNCTION Syntax
    19.2.3. DROP FUNCTION Syntax
    19.2.4. Adding a New User-Defined Function
    19.2.5. Adding a New Native Function
    19.3. Adding New Procedures to MySQL
    19.3.1. Procedure Analyse
    19.3.2. Writing a Procedure
    A. Errors, Error Codes, and Common Problems
    A.1. Problems and Common Errors
    A.1.1. How to Determine What Is Causing a Problem
    A.1.2. Common Errors When Using MySQL Programs
    A.1.3. Installation-Related Issues
    A.1.4. Administration-Related Issues
    A.1.5. Query-Related Issues
    A.1.6. Optimizer-Related Issues
    A.1.7. Table Definition-Related Issues
    A.1.8. Known Issues in MySQL
    A.2. Server Error Codes and Messages
    A.3. Client Error Codes and Messages
    B. MySQL Change History
    B.1. Changes in release 4.1.x (Production)
    B.1.1. Changes in release 4.1.24 (Not yet released)
    B.1.2. Changes in release 4.1.23 (12 June 2007)
    B.1.3. Changes in release 4.1.22 (02 November 2006)
    B.1.4. Changes in release 4.1.21 (19 July 2006)
    B.1.5. Changes in release 4.1.20 (24 May 2006)
    B.1.6. Changes in release 4.1.19 (29 April 2006)
    B.1.7. Changes in release 4.1.18 (27 January 2006)
    B.1.8. Changes in release 4.1.17 (Not released)
    B.1.9. Changes in release 4.1.16 (29 November 2005)
    B.1.10. Changes in release 4.1.15 (13 October 2005)
    B.1.11. Changes in release 4.1.14 (17 August 2005)
    B.1.12. Changes in release 4.1.13 (15 July 2005)
    B.1.13. Changes in release 4.1.12 (13 May 2005)
    B.1.14. Changes in release 4.1.11 (01 April 2005)
    B.1.15. Changes in release 4.1.10 (12 February 2005)
    B.1.16. Changes in release 4.1.9 (11 January 2005)
    B.1.17. Changes in release 4.1.8 (14 December 2004)
    B.1.18. Changes in release 4.1.7 (23 October 2004: Production)
    B.1.19. Changes in release 4.1.6 (10 October 2004)
    B.1.20. Changes in release 4.1.5 (16 September 2004)
    B.1.21. Changes in release 4.1.4 (26 August 2004: Gamma)
    B.1.22. Changes in release 4.1.3 (28 June 2004: Beta)
    B.1.23. Changes in release 4.1.2 (28 May 2004)
    B.1.24. Changes in release 4.1.1 (01 December 2003)
    B.1.25. Changes in release 4.1.0 (03 April 2003: Alpha)
    B.2. Changes in release 4.0.x
    B.2.1. Changes in release 4.0.30 (12 February 2007)
    B.2.2. Changes in release 4.0.29 (Not released)
    B.2.3. Changes in release 4.0.28 (Not released)
    B.2.4. Changes in release 4.0.27 (06 May 2006)
    B.2.5. Changes in release 4.0.26 (08 September 2005)
    B.2.6. Changes in release 4.0.25 (05 July 2005)
    B.2.7. Changes in release 4.0.24 (04 March 2005)
    B.2.8. Changes in release 4.0.23 (18 December 2004)
    B.2.9. Changes in release 4.0.22 (27 October 2004)
    B.2.10. Changes in release 4.0.21 (06 September 2004)
    B.2.11. Changes in release 4.0.20 (17 May 2004)
    B.2.12. Changes in release 4.0.19 (04 May 2004)
    B.2.13. Changes in release 4.0.18 (12 February 2004)
    B.2.14. Changes in release 4.0.17 (14 December 2003)
    B.2.15. Changes in release 4.0.16 (17 October 2003)
    B.2.16. Changes in release 4.0.15 (03 September 2003)
    B.2.17. Changes in release 4.0.14 (18 July 2003)
    B.2.18. Changes in release 4.0.13 (16 May 2003)
    B.2.19. Changes in release 4.0.12 (15 March 2003: Production)
    B.2.20. Changes in release 4.0.11 (20 February 2003)
    B.2.21. Changes in release 4.0.10 (29 January 2003)
    B.2.22. Changes in release 4.0.9 (09 January 2003)
    B.2.23. Changes in release 4.0.8 (07 January 2003)
    B.2.24. Changes in release 4.0.7 (20 December 2002)
    B.2.25. Changes in release 4.0.6 (14 December 2002: Gamma)
    B.2.26. Changes in release 4.0.5 (13 November 2002)
    B.2.27. Changes in release 4.0.4 (29 September 2002)
    B.2.28. Changes in release 4.0.3 (26 August 2002: Beta)
    B.2.29. Changes in release 4.0.2 (01 July 2002)
    B.2.30. Changes in release 4.0.1 (23 December 2001)
    B.2.31. Changes in release 4.0.0 (October 2001: Alpha)
    B.3. Changes in release 3.23.x
    B.3.1. Changes in release 3.23.59 (Not yet released)
    B.3.2. Changes in release 3.23.58 (11 September 2003)
    B.3.3. Changes in release 3.23.57 (06 June 2003)
    B.3.4. Changes in release 3.23.56 (13 March 2003)
    B.3.5. Changes in release 3.23.55 (23 January 2003)
    B.3.6. Changes in release 3.23.54 (05 December 2002)
    B.3.7. Changes in release 3.23.53 (09 October 2002)
    B.3.8. Changes in release 3.23.52 (14 August 2002)
    B.3.9. Changes in release 3.23.51 (31 May 2002)
    B.3.10. Changes in release 3.23.50 (21 April 2002)
    B.3.11. Changes in release 3.23.49 (14 February 2002)
    B.3.12. Changes in release 3.23.48 (07 February 2002)
    B.3.13. Changes in release 3.23.47 (27 December 2001)
    B.3.14. Changes in release 3.23.46 (29 November 2001)
    B.3.15. Changes in release 3.23.45 (22 November 2001)
    B.3.16. Changes in release 3.23.44 (31 October 2001)
    B.3.17. Changes in release 3.23.43 (04 October 2001)
    B.3.18. Changes in release 3.23.42 (08 September 2001)
    B.3.19. Changes in release 3.23.41 (11 August 2001)
    B.3.20. Changes in release 3.23.40 (18 July 2001)
    B.3.21. Changes in release 3.23.39 (12 June 2001)
    B.3.22. Changes in release 3.23.38 (09 May 2001)
    B.3.23. Changes in release 3.23.37 (17 April 2001)
    B.3.24. Changes in release 3.23.36 (27 March 2001)
    B.3.25. Changes in release 3.23.35 (15 March 2001)
    B.3.26. Changes in release 3.23.34a (11 March 2001)
    B.3.27. Changes in release 3.23.34 (10 March 2001)
    B.3.28. Changes in release 3.23.33 (09 February 2001)
    B.3.29. Changes in release 3.23.32 (22 January 2001)
    B.3.30. Changes in release 3.23.31 (17 January 2001: Production)
    B.3.31. Changes in release 3.23.30 (04 January 2001)
    B.3.32. Changes in release 3.23.29 (16 December 2000)
    B.3.33. Changes in release 3.23.28 (22 November 2000: Gamma)
    B.3.34. Changes in release 3.23.27 (24 October 2000)
    B.3.35. Changes in release 3.23.26 (18 October 2000)
    B.3.36. Changes in release 3.23.25 (29 September 2000)
    B.3.37. Changes in release 3.23.24 (08 September 2000)
    B.3.38. Changes in release 3.23.23 (01 September 2000)
    B.3.39. Changes in release 3.23.22 (31 July 2000)
    B.3.40. Changes in release 3.23.21 (04 July 2000)
    B.3.41. Changes in release 3.23.20 (28 June 2000: Beta)
    B.3.42. Changes in release 3.23.19
    B.3.43. Changes in release 3.23.18 (11 June 2000)
    B.3.44. Changes in release 3.23.17 (07 June 2000)
    B.3.45. Changes in release 3.23.16 (16 May 2000)
    B.3.46. Changes in release 3.23.15 (08 May 2000)
    B.3.47. Changes in release 3.23.14 (09 April 2000)
    B.3.48. Changes in release 3.23.13 (14 March 2000)
    B.3.49. Changes in release 3.23.12 (07 March 2000)
    B.3.50. Changes in release 3.23.11 (16 February 2000)
    B.3.51. Changes in release 3.23.10 (30 January 2000)
    B.3.52. Changes in release 3.23.9 (29 January 2000)
    B.3.53. Changes in release 3.23.8 (02 January 2000)
    B.3.54. Changes in release 3.23.7 (10 December 1999)
    B.3.55. Changes in release 3.23.6 (15 December 1999)
    B.3.56. Changes in release 3.23.5 (20 October 1999)
    B.3.57. Changes in release 3.23.4 (28 September 1999)
    B.3.58. Changes in release 3.23.3 (13 September 1999)
    B.3.59. Changes in release 3.23.2 (09 August 1999)
    B.3.60. Changes in release 3.23.1 (08 July 1999)
    B.3.61. Changes in release 3.23.0 (05 July 1999: Alpha)
    B.4. Changes in InnoDB
    B.4.1. Changes in MySQL/InnoDB-4.0.21, September 10, 2004
    B.4.2. Changes in MySQL/InnoDB-4.1.4, August 31, 2004
    B.4.3. Changes in MySQL/InnoDB-4.1.3, June 28, 2004
    B.4.4. Changes in MySQL/InnoDB-4.1.2, May 30, 2004
    B.4.5. Changes in MySQL/InnoDB-4.0.20, May 18, 2004
    B.4.6. Changes in MySQL/InnoDB-4.0.19, May 4, 2004
    B.4.7. Changes in MySQL/InnoDB-4.0.18, February 13, 2004
    B.4.8. Changes in MySQL/InnoDB-5.0.0, December 24, 2003
    B.4.9. Changes in MySQL/InnoDB-4.0.17, December 17, 2003
    B.4.10. Changes in MySQL/InnoDB-4.1.1, December 4, 2003
    B.4.11. Changes in MySQL/InnoDB-4.0.16, October 22, 2003
    B.4.12. Changes in MySQL/InnoDB-3.23.58, September 15, 2003
    B.4.13. Changes in MySQL/InnoDB-4.0.15, September 10, 2003
    B.4.14. Changes in MySQL/InnoDB-4.0.14, July 22, 2003
    B.4.15. Changes in MySQL/InnoDB-3.23.57, June 20, 2003
    B.4.16. Changes in MySQL/InnoDB-4.0.13, May 20, 2003
    B.4.17. Changes in MySQL/InnoDB-4.1.0, April 3, 2003
    B.4.18. Changes in MySQL/InnoDB-3.23.56, March 17, 2003
    B.4.19. Changes in MySQL/InnoDB-4.0.12, March 18, 2003
    B.4.20. Changes in MySQL/InnoDB-4.0.11, February 25, 2003
    B.4.21. Changes in MySQL/InnoDB-4.0.10, February 4, 2003
    B.4.22. Changes in MySQL/InnoDB-3.23.55, January 24, 2003
    B.4.23. Changes in MySQL/InnoDB-4.0.9, January 14, 2003
    B.4.24. Changes in MySQL/InnoDB-4.0.8, January 7, 2003
    B.4.25. Changes in MySQL/InnoDB-4.0.7, December 26, 2002
    B.4.26. Changes in MySQL/InnoDB-4.0.6, December 19, 2002
    B.4.27. Changes in MySQL/InnoDB-3.23.54, December 12, 2002
    B.4.28. Changes in MySQL/InnoDB-4.0.5, November 18, 2002
    B.4.29. Changes in MySQL/InnoDB-3.23.53, October 9, 2002
    B.4.30. Changes in MySQL/InnoDB-4.0.4, October 2, 2002
    B.4.31. Changes in MySQL/InnoDB-4.0.3, August 28, 2002
    B.4.32. Changes in MySQL/InnoDB-3.23.52, August 16, 2002
    B.4.33. Changes in MySQL/InnoDB-4.0.2, July 10, 2002
    B.4.34. Changes in MySQL/InnoDB-3.23.51, June 12, 2002
    B.4.35. Changes in MySQL/InnoDB-3.23.50, April 23, 2002
    B.4.36. Changes in MySQL/InnoDB-3.23.49, February 17, 2002
    B.4.37. Changes in MySQL/InnoDB-3.23.48, February 9, 2002
    B.4.38. Changes in MySQL/InnoDB-3.23.47, December 28, 2001
    B.4.39. Changes in MySQL/InnoDB-4.0.1, December 23, 2001
    B.4.40. Changes in MySQL/InnoDB-3.23.46, November 30, 2001
    B.4.41. Changes in MySQL/InnoDB-3.23.45, November 23, 2001
    B.4.42. Changes in MySQL/InnoDB-3.23.44, November 2, 2001
    B.4.43. Changes in MySQL/InnoDB-3.23.43, October 4, 2001
    B.4.44. Changes in MySQL/InnoDB-3.23.42, September 9, 2001
    B.4.45. Changes in MySQL/InnoDB-3.23.41, August 13, 2001
    B.4.46. Changes in MySQL/InnoDB-3.23.40, July 16, 2001
    B.4.47. Changes in MySQL/InnoDB-3.23.39, June 13, 2001
    B.4.48. Changes in MySQL/InnoDB-3.23.38, May 12, 2001
    B.5. Changes in MySQL Cluster
    B.5.1. Changes in MySQL Cluster-5.0.7 (10 June 2005)
    B.5.2. Changes in MySQL Cluster-5.0.6 (26 May 2005)
    B.5.3. Changes in MySQL Cluster-5.0.5 (Not released)
    B.5.4. Changes in MySQL Cluster-5.0.4 (16 April 2005)
    B.5.5. Changes in MySQL Cluster-5.0.3 (23 March 2005: Beta)
    B.5.6. Changes in MySQL Cluster-5.0.1 (27 July 2004)
    B.5.7. Changes in MySQL Cluster-4.1.13 (15 July 2005)
    B.5.8. Changes in MySQL Cluster-4.1.12 (13 May 2005)
    B.5.9. Changes in MySQL Cluster-4.1.11 (01 April 2005)
    B.5.10. Changes in MySQL Cluster-4.1.10 (12 February 2005)
    B.5.11. Changes in MySQL Cluster-4.1.9 (13 January 2005)
    B.5.12. Changes in MySQL Cluster-4.1.8 (14 December 2004)
    B.5.13. Changes in MySQL Cluster-4.1.7 (23 October 2004)
    B.5.14. Changes in MySQL Cluster-4.1.6 (10 October 2004)
    B.5.15. Changes in MySQL Cluster-4.1.5 (16 September 2004)
    B.5.16. Changes in MySQL Cluster-4.1.4 (31 August 2004)
    B.5.17. Changes in MySQL Cluster-4.1.3 (28 June 2004)
    B.6. MySQL Connector/ODBC (MyODBC) Change History
    B.6.1. Changes in Connector/ODBC 5.0.12 (Not yet released)
    B.6.2. Changes in Connector/ODBC 5.0.11 (31 January 2007)
    B.6.3. Changes in Connector/ODBC 5.0.10 (14 December 2006)
    B.6.4. Changes in Connector/ODBC 5.0.9 (22 November 2006)
    B.6.5. Changes in Connector/ODBC 5.0.8 (17 November 2006)
    B.6.6. Changes in Connector/ODBC 5.0.7 (08 November 2006)
    B.6.7. Changes in Connector/ODBC 5.0.6 (03 November 2006)
    B.6.8. Changes in Connector/ODBC 5.0.5 (17 October 2006)
    B.6.9. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June 2006)
    B.6.10. Changes in Connector/ODBC 5.0.2 (Never released)
    B.6.11. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June 2006)
    B.6.12. Changes in Connector/ODBC 3.51.17 (Not yet released)
    B.6.13. Changes in Connector/ODBC 3.51.16 (14 June 2007)
    B.6.14. Changes in Connector/ODBC 3.51.15 (7 May 2007)
    B.6.15. Changes in Connector/ODBC 3.51.14 (08 March 2007)
    B.6.16. Changes in Connector/ODBC 3.51.13 (Never released)
    B.6.17. Changes in Connector/ODBC 3.51.12
    B.6.18. Changes in Connector/ODBC 3.51.11
    B.7. Connector/NET Change History
    B.7.1. Changes in MySQL Connector/NET Version 5.1.3 (Not yet released)
    B.7.2. Changes in MySQL Connector/NET Version 5.1.2 (Not yet released)
    B.7.3. Changes in MySQL Connector/NET Version 5.1.1 (23 May 2007)
    B.7.4. Changes in MySQL Connector/NET Version 5.1.0 (01 May 2007)
    B.7.5. Changes in MySQL Connector/NET Version 5.0.8 (Not yet released)
    B.7.6. Changes in MySQL Connector/NET Version 5.0.7 (18 May 2007)
    B.7.7. Changes in MySQL Connector/NET Version 5.0.6 (22 March 2007)
    B.7.8. Changes in MySQL Connector/NET Version 5.0.5 (07 March 2007)
    B.7.9. Changes in MySQL Connector/NET Version 5.0.4 (Not released)
    B.7.10. Changes in MySQL Connector/NET Version 5.0.3 (05 January 2007)
    B.7.11. Changes in MySQL Connector/NET Version 5.0.2 (06 November 2006)
    B.7.12. Changes in MySQL Connector/NET Version 5.0.1 (01 October 2006)
    B.7.13. Changes in MySQL Connector/NET Version 5.0.0 (08 August 2006)
    B.7.14. Changes in MySQL Connector/NET Version 1.0.10 (Not yet released)
    B.7.15. Changes in MySQL Connector/NET Version 1.0.9 (02 February 2007
    B.7.16. Changes in MySQL Connector/NET Version 1.0.8 (20 October 2006)
    B.7.17. Changes in MySQL Connector/NET Version 1.0.7 (21 November 2005)
    B.7.18. Changes in MySQL Connector/NET Version 1.0.6 (03 October 2005)
    B.7.19. Changes in MySQL Connector/NET Version 1.0.5 (29 August 2005)
    B.7.20. Changes in MySQL Connector/NET Version 1.0.4 (20 January 2005)
    B.7.21. Changes in MySQL Connector/NET Version 1.0.3-gamma (12 October 2004)
    B.7.22. Changes in MySQL Connector/NET Version 1.0.2-gamma (15 November 2004)
    B.7.23. Changes in MySQL Connector/NET Version 1.0.1-beta2 (27 October 2004)
    B.7.24. Changes in MySQL Connector/NET Version 1.0.0 (01 September 2004)
    B.7.25. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
    B.7.26. Changes in MySQL Connector/NET Version 0.76
    B.7.27. Changes in MySQL Connector/NET Version 0.75
    B.7.28. Changes in MySQL Connector/NET Version 0.74
    B.7.29. Changes in MySQL Connector/NET Version 0.71
    B.7.30. Changes in MySQL Connector/NET Version 0.70
    B.7.31. Changes in MySQL Connector/NET Version 0.68
    B.7.32. Changes in MySQL Connector/NET Version 0.65
    B.7.33. Changes in MySQL Connector/NET Version 0.60
    B.7.34. Changes in MySQL Connector/NET Version 0.50
    B.8. MySQL Connector/J Change History
    B.8.1. Changes in MySQL Connector/J 5.1.x
    B.8.2. Changes in MySQL Connector/J 5.0.x
    B.8.3. Changes in MySQL Connector/J 3.1.x
    B.8.4. Changes in MySQL Connector/J 3.0.x
    B.8.5. Changes in MySQL Connector/J 2.0.x
    B.8.6. Changes in MySQL Connector/J 1.2b (04 July 1999)
    B.8.7. Changes in MySQL Connector/J 1.2.x and lower
    B.9. MySQL Connector/MXJ Change History
    B.9.1. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)
    B.9.2. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)
    B.9.3. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)
    B.9.4. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)
    B.9.5. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)
    B.9.6. Changes in MySQL Connector/MXJ 5.0.1 (Never released)
    B.9.7. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)
    C. Limits and Restrictions
    C.1. Restrictions on Subqueries
    C.2. Limits in MySQL
    C.2.1. Limits of Joins
    D. Credits
    D.1. Developers at MySQL AB
    D.2. Contributors to MySQL
    D.3. Documenters and translators
    D.4. Libraries used by and included with MySQL
    D.5. Packages that support MySQL
    D.6. Tools that were used to create MySQL
    D.7. Supporters of MySQL
    Index
    List of Tables

    18.1. Mapping of MySQL Error Numbers to SQLStates
    List of Examples

    18.1. Obtaining a connection from the DriverManager
    18.2. Using java.sql.Statement to execute a SELECT query
    18.3. Stored Procedures
    18.4. Using Connection.prepareCall()
    18.5. Registering output parameters
    18.6. Setting CallableStatement input parameters
    18.7. Retrieving results and output parameter values
    18.8. Retrieving AUTO_INCREMENT column values using Statement.getGeneratedKeys()
    18.9. Retrieving AUTO_INCREMENT column values using SELECT LAST_INSERT_ID()
    18.10. Retrieving AUTO_INCREMENT column values in Updatable ResultSets
    18.11. Using a connection pool with a J2EE application server
    18.12. Example of transaction with retry logic
     
  3. Sirus-v

    Sirus-v کاربر تازه وارد

    تاریخ عضویت:
    ‏3 نوامبر 2006
    نوشته ها:
    45
    تشکر شده:
    0
    محل سکونت:
    Silent Hill
    نیازی به این کار نیست . می تونید خیلی راحت موقع خوندن اطلاعات داخل query از این دستور استفاده کنید :
    order by id desc
    البته لازمش وجود فیلد id هست که 99% توی هر table ای هست .
     
avanak عسل طبیعی و گرده گل ایرانی