PDF (US Ltr)
- 4.5Mb
PDF (A4)
- 4.5Mb
Abstract
This manual describes the Connectors and APIs that can be used with MySQL.
For legal information, see the Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2024-10-13 (revision: 80007)
Table of Contents
- Preface and Legal Notices
- 1 Introduction
- 2 MySQL Connector/C++ Developer Guide
- 3 MySQL Connector/J Developer Guide
- 3.1 Overview of MySQL Connector/J
- 3.2 Compatibility with MySQL and Java Versions
- 3.3 Connector/J Installation
- 3.4 Connector/J Examples
- 3.5 Connector/J Reference
- 3.5.1 Driver/Datasource Class Name
- 3.5.2 Connection URL Syntax
- 3.5.3 Configuration Properties
- 3.5.4 JDBC API Implementation Notes
- 3.5.5 Java, JDBC, and MySQL Types
- 3.5.6 Handling of Date-Time Values
- 3.5.7 Using Character Sets and Unicode
- 3.5.8 Using Query Attributes
- 3.5.9 Connecting Securely Using SSL
- 3.5.10 Connecting Using Unix Domain Sockets
- 3.5.11 Connecting Using Named Pipes
- 3.5.12 Connecting Using Various Authentication Methods
- 3.5.13 Using Source/Replica Replication with ReplicationConnection
- 3.5.14 Support for DNS SRV Records
- 3.5.15 Client Session State Tracker
- 3.5.16 Mapping MySQL Error Numbers to JDBC SQLState Codes
- 3.6 JDBC Concepts
- 3.7 Connection Pooling with Connector/J
- 3.8 Multi-Host Connections
- 3.9 Using the X DevAPI with Connector/J: Special Topics
- 3.10 Using the Connector/J Interceptor Classes
- 3.11 Using Logging Frameworks with SLF4J
- 3.12 Using Connector/J with Tomcat
- 3.13 Using Connector/J with Spring
- 3.14 Troubleshooting Connector/J Applications
- 3.15 Known Issues and Limitations
- 3.16 Connector/J Support
- 4 MySQL Connector/NET Developer Guide
- 4.1 Introduction to MySQL Connector/NET
- 4.2 Connector/NET Versions
- 4.3 Connector/NET Installation
- 4.4 Connector/NET Connections
- 4.5 Connector/NET Programming
- 4.5.1 Using GetSchema on a Connection
- 4.5.2 Using MySqlCommand
- 4.5.3 Using Connector/NET with Table Caching
- 4.5.4 Preparing Statements in Connector/NET
- 4.5.5 Creating and Calling Stored Procedures
- 4.5.6 Handling BLOB Data With Connector/NET
- 4.5.7 Working with Partial Trust / Medium Trust
- 4.5.8 Writing a Custom Authentication Plugin
- 4.5.9 Using the Connector/NET Interceptor Classes
- 4.5.10 Handling Date and Time Information in Connector/NET
- 4.5.11 Using the MySqlBulkLoader Class
- 4.5.12 Connector/NET Tracing
- 4.5.13 Using Connector/NET with Crystal Reports
- 4.5.14 Asynchronous Methods
- 4.5.15 Binary and Nonbinary Issues
- 4.5.16 Character Set Considerations for Connector/NET
- 4.6 Connector/NET Tutorials
- 4.6.1 Tutorial: An Introduction to Connector/NET Programming
- 4.6.2 ASP.NET Provider Model and Tutorials
- 4.6.3 Tutorial: Using an Entity Framework Entity as a Windows Forms Data Source
- 4.6.4 Tutorial: Data Binding in ASP.NET Using LINQ on Entities
- 4.6.5 Tutorial: Generating MySQL DDL from an Entity Framework Model
- 4.6.6 Tutorial: Basic CRUD Operations with Connector/NET
- 4.6.7 Tutorial: Configuring SSL with Connector/NET
- 4.6.8 Tutorial: Using MySqlScript
- 4.7 Connector/NET for Entity Framework
- 4.8 Connector/NET API Reference
- 4.8.1 MySql.Data.Common.DnsClient
- 4.8.2 MySql.Data.MySqlClient Namespace
- 4.8.3 MySql.Data.MySqlClient.Authentication Namespace
- 4.8.4 MySql.Data.MySqlClient.Interceptors Namespace
- 4.8.5 MySql.Data.MySqlClient.Replication Namespace
- 4.8.6 MySql.Data.Types Namespace
- 4.8.7 MySql.Data.EntityFramework Namespace
- 4.8.8 Microsoft.EntityFrameworkCore Namespace
- 4.8.9 MySql.EntityFrameworkCore Namespace
- 4.8.10 MySql.Web Namespace
- 4.9 Connector/NET Support
- 5 MySQL Connector/ODBC Developer Guide
- 5.1 Introduction to MySQL Connector/ODBC
- 5.2 Connector/ODBC Versions
- 5.3 General Information About ODBC and Connector/ODBC
- 5.4 Connector/ODBC Installation
- 5.4.1 Installing Connector/ODBC on Windows
- 5.4.2 Installing Connector/ODBC on Unix-like Systems
- 5.4.3 Installing Connector/ODBC on macOS
- 5.4.4 Building Connector/ODBC from a Source Distribution on Windows
- 5.4.5 Building Connector/ODBC from a Source Distribution on Unix
- 5.4.6 Building Connector/ODBC from a Source Distribution on macOS
- 5.4.7 Installing Connector/ODBC from the Development Source Tree
- 5.5 Configuring Connector/ODBC
- 5.5.1 Overview of Connector/ODBC Data Source Names
- 5.5.2 Connector/ODBC Connection Parameters
- 5.5.3 Configuring a Connector/ODBC DSN on Windows
- 5.5.4 Configuring a Connector/ODBC DSN on macOS
- 5.5.5 Configuring a Connector/ODBC DSN on Unix
- 5.5.6 Connecting Without a Predefined DSN
- 5.5.7 ODBC Connection Pooling
- 5.5.8 OpenTelemetry Tracing Support
- 5.5.9 Authentication Options
- 5.5.10 Getting an ODBC Trace File
- 5.6 Connector/ODBC Examples
- 5.6.1 Basic Connector/ODBC Application Steps
- 5.6.2 Step-by-step Guide to Connecting to a MySQL Database through Connector/ODBC
- 5.6.3 Connector/ODBC and Third-Party ODBC Tools
- 5.6.4 Using Connector/ODBC with Microsoft Access
- 5.6.5 Using Connector/ODBC with Microsoft Word or Excel
- 5.6.6 Using Connector/ODBC with Crystal Reports
- 5.6.7 Connector/ODBC Programming
- 5.7 Connector/ODBC Reference
- 5.8 Connector/ODBC Notes and Tips
- 5.9 Connector/ODBC Support
- 6 MySQL Connector/Python Developer Guide
- 6.1 Introduction to MySQL Connector/Python
- 6.2 Guidelines for Python Developers
- 6.3 Connector/Python Versions
- 6.4 Connector/Python Installation
- 6.5 Connector/Python Coding Examples
- 6.6 Connector/Python Tutorials
- 6.7 Connector/Python Connection Establishment
- 6.8 Connector/Python Other Topics
- 6.9 Connector/Python API Reference
- 6.9.1 mysql.connector Module
- 6.9.2 connection.MySQLConnection Class
- 6.9.3 pooling.MySQLConnectionPool Class
- 6.9.4 pooling.PooledMySQLConnection Class
- 6.9.5 cursor.MySQLCursor Class
- 6.9.6 Subclasses cursor.MySQLCursor
- 6.9.7 constants.ClientFlag Class
- 6.9.8 constants.FieldType Class
- 6.9.9 constants.SQLMode Class
- 6.9.10 constants.CharacterSet Class
- 6.9.11 constants.RefreshOption Class
- 6.9.12 Errors and Exceptions
- 7 MySQL and PHP