没有合适的资源?快使用搜索试试~ 我知道了~
首页MySQL 5.5官方参考手册:包括MySQL Cluster NDB 7.2
"MySQL 5.5 参考手册(英文版) - MySQL 5.5的官方原始文档,包括MySQL Cluster NDB 7.2参考指南。"
MySQL 5.5参考手册是针对该数据库版本的权威性文档,涵盖了从5.5.25到MySQL Cluster基于7.2版本的5.5.20-ndb-7.2.6的所有信息。手册旨在提供详尽的MySQL 5.5特性和功能,包括MySQL Cluster的相关内容。MySQL Cluster(NDBCLUSTER)是一种高可用性和可扩展性的存储引擎,提供了数据的自动复制和分布式处理能力。
在手册中,开发者和管理员可以找到关于以下主题的详细信息:
1. **开始使用**:这部分通常包括安装指南,适用于各种平台,如Linux/Unix、MacOSX等,指导用户如何下载、安装和配置MySQL 5.5服务器。
2. **服务器选项和变量参考**:列出了所有可用于启动MySQL服务器的命令行选项以及系统和会话级别的变量,帮助管理员调整服务器性能和行为。
3. **SQL语法**:详细阐述了MySQL 5.5支持的SQL语言结构和语句,包括数据查询、数据修改、事务处理、视图创建、存储过程和触发器等。
4. **开发者信息**:对于应用程序开发者,手册提供了关于连接器的信息,例如`Connector/J`,这是用于Java应用程序的JDBC驱动程序,以及其他编程语言的接口,以便于开发人员将MySQL集成到他们的项目中。
5. **高可用性与可扩展性**:介绍了如何实现MySQL的高可用性和可扩展性,包括复制、故障转移策略、集群配置等,以确保数据的安全性和系统的稳定性。
6. **变更历史**:记录了MySQL 5.5版本的更新和改进,这对于跟踪新功能和修复的bug非常有用。
7. **视图和存储程序**:这部分涵盖了如何创建和使用视图以及编写和管理存储过程,这些是数据库中的高级特性,可以提升数据库的复杂性和灵活性。
由于手册是英文版,对于非英语使用者可能会有一些阅读上的挑战。然而,它提供了最全面和最新的MySQL 5.5功能说明,是学习和解决MySQL问题的重要资源。如果你在使用过程中遇到任何关于所包含功能的问题,应查阅你的MySQL 5.5许可协议或联系Oracle的销售代表以获取明确的信息。
22.2.2. Installing Connector/Net ....................................................................................... 2065
22.2.3. Connector/Net Visual Studio Integration .................................................................... 2072
22.2.4. Connector/Net Tutorials ........................................................................................ 2096
22.2.5. Connector/Net Programming .................................................................................. 2136
22.2.6. Connector/Net Connection String Options Reference ..................................................... 2164
22.2.7. Connector/Net API Reference ................................................................................. 2168
22.2.8. Connector/Net Support ......................................................................................... 2263
22.2.9. Connector/Net FAQ ............................................................................................ 2264
22.3. MySQL Connector/J ...................................................................................................... 2265
22.3.1. Overview of MySQL Connector/J ............................................................................ 2265
22.3.2. Connector/J Versions ........................................................................................... 2266
22.3.3. Connector/J Installation ........................................................................................ 2267
22.3.4. Connector/J Examples .......................................................................................... 2270
22.3.5. Connector/J (JDBC) Reference ............................................................................... 2271
22.3.6. JDBC Concepts ................................................................................................. 2296
22.3.7. Developing J2EE Applications with Connector/J .......................................................... 2303
22.3.8. Using Connector/J with Tomcat .............................................................................. 2309
22.3.9. Using Connector/J with JBoss ................................................................................ 2310
22.3.10. Using Connector/J with Spring .............................................................................. 2310
22.3.11. Using Connector/J with GlassFish .......................................................................... 2314
22.3.12. Troubleshooting Connector/J Applications ................................................................ 2318
22.3.13. Connector/J Support ........................................................................................... 2325
22.4. MySQL Connector/MXJ ................................................................................................. 2326
22.4.1. Overview of Connector/MXJ .................................................................................. 2326
22.4.2. Connector/MXJ Versions ...................................................................................... 2327
22.4.3. Connector/MXJ Installation ................................................................................... 2328
22.4.4. Connector/MXJ Configuration ................................................................................ 2332
22.4.5. Connector/MXJ Reference ..................................................................................... 2334
22.4.6. Connector/MXJ Notes and Tips ............................................................................... 2335
22.4.7. Connector/MXJ Samples ....................................................................................... 2339
22.4.8. Connector/MXJ Support ....................................................................................... 2342
22.5. MySQL Connector/C++ .................................................................................................. 2343
22.5.1. Installing the MySQL Connector/C++ Binary .............................................................. 2345
22.5.2. Installing MySQL Connector/C++ from Source ............................................................ 2349
22.5.3. MySQL Connector/C++ Building Windows Applications with Microsoft Visual Studio ............ 2353
22.5.4. MySQL Connector/C++ Building Linux Applications with NetBeans .................................. 2365
22.5.5. MySQL Connector/C++ Getting Started: Usage Examples ............................................... 2370
22.5.6. MySQL Connector/C++ Tutorials ............................................................................ 2375
22.5.7. MySQL Connector/C++ Debug Tracing ..................................................................... 2381
22.5.8. MySQL Connector/C++ Usage Notes ....................................................................... 2382
22.5.9. MySQL Connector/C++ Known Bugs and Issues .......................................................... 2385
22.5.10. MySQL Connector/C++ Feature requests .................................................................. 2385
22.5.11. MySQL Connector/C++ Support ............................................................................ 2386
22.5.12. MySQL Connector/C++ FAQ ............................................................................... 2386
22.6. MySQL Connector/C ..................................................................................................... 2386
22.6.1. Building MySQL Connector/C from the Source Code .................................................... 2387
22.6.2. Testing MySQL Connector/C ................................................................................. 2389
22.6.3. MySQL Connector/C FAQ .................................................................................... 2389
22.7. MySQL Connector/OpenOffice.org .................................................................................... 2390
22.7.1. Installation ....................................................................................................... 2390
22.7.2. Getting Started: Connecting to MySQL ..................................................................... 2391
22.7.3. Getting Started: Usage Examples ............................................................................. 2396
22.7.4. References ....................................................................................................... 2396
22.7.5. Known Bugs ..................................................................................................... 2396
22.7.6. Contact ........................................................................................................... 2396
22.8. libmysqld, the Embedded MySQL Server Library ................................................................... 2396
22.8.1. Compiling Programs with libmysqld ..................................................................... 2397
22.8.2. Restrictions When Using the Embedded MySQL Server ................................................. 2397
22.8.3. Options with the Embedded Server ........................................................................... 2398
22.8.4. Embedded Server Examples ................................................................................... 2398
22.8.5. Licensing the Embedded Server .............................................................................. 2400
22.9. MySQL C API ............................................................................................................. 2400
22.9.1. C API Data Structures .......................................................................................... 2401
22.9.2. C API Function Overview ..................................................................................... 2405
22.9.3. C API Function Descriptions .................................................................................. 2408
22.9.4. C API Prepared Statements .................................................................................... 2449
22.9.5. C API Prepared Statement Data Structures .................................................................. 2450
22.9.6. C API Prepared Statement Function Overview ............................................................. 2455
22.9.7. C API Prepared Statement Function Descriptions .......................................................... 2457
22.9.8. C API Threaded Function Descriptions ...................................................................... 2476
MySQL 5.5 Reference Manual
xvi
22.9.9. C API Embedded Server Function Descriptions ............................................................ 2477
22.9.10. C API Client Plugin Functions .............................................................................. 2478
22.9.11. Common Questions and Problems When Using the C API .............................................. 2480
22.9.12. Controlling Automatic Reconnection Behavior ........................................................... 2482
22.9.13. C API Support for Multiple Statement Execution ........................................................ 2483
22.9.14. C API Prepared Statement Problems ....................................................................... 2484
22.9.15. C API Prepared Statement Handling of Date and Time Values ......................................... 2485
22.9.16. C API Support for Prepared CALL Statements ............................................................ 2486
22.9.17. Building Client Programs .................................................................................... 2489
22.10. MySQL PHP API ........................................................................................................ 2491
22.10.1. Overview of the MySQL PHP drivers ...................................................................... 2491
22.10.2. Original MySQL API (Mysql) ............................................................................. 2495
22.10.3. MySQL Improved Extension (Mysqli) ................................................................... 2553
22.10.4. MySQL Native Driver (Mysqlnd) ......................................................................... 2738
22.10.5. MySQL Functions (PDO_MYSQL) (MySQL (PDO)) .................................................. 2776
22.10.6. Connector/PHP ................................................................................................ 2779
22.10.7. Common Problems with MySQL and PHP ................................................................ 2779
22.10.8. Enabling Both mysql and mysqli in PHP .............................................................. 2779
22.11. MySQL Perl API ......................................................................................................... 2780
22.12. MySQL Python API ..................................................................................................... 2781
22.13. MySQL Ruby APIs ...................................................................................................... 2782
22.13.1. The MySQL/Ruby API ....................................................................................... 2782
22.13.2. The Ruby/MySQL API ....................................................................................... 2782
22.14. MySQL Tcl API ......................................................................................................... 2782
22.15. MySQL Eiffel Wrapper ................................................................................................. 2782
23. Extending MySQL .................................................................................................................. 2783
23.1. MySQL Internals .......................................................................................................... 2783
23.1.1. MySQL Threads ................................................................................................. 2783
23.1.2. The MySQL Test Suite ......................................................................................... 2784
23.2. The MySQL Plugin API .................................................................................................. 2784
23.2.1. Plugin API Characteristics ..................................................................................... 2785
23.2.2. Plugin API Components ....................................................................................... 2786
23.2.3. Types of Plugins ................................................................................................ 2786
23.2.4. Writing Plugins .................................................................................................. 2789
23.2.5. MySQL Services for Plugins .................................................................................. 2819
23.3. Adding New Functions to MySQL ..................................................................................... 2821
23.3.1. Features of the User-Defined Function Interface ........................................................... 2821
23.3.2. Adding a New User-Defined Function ....................................................................... 2821
23.3.3. Adding a New Native Function ............................................................................... 2829
23.4. Adding New Procedures to MySQL .................................................................................... 2830
23.4.1. PROCEDURE ANALYSE ...................................................................................... 2830
23.4.2. Writing a Procedure ............................................................................................ 2831
23.5. Debugging and Porting MySQL ........................................................................................ 2831
23.5.1. Debugging a MySQL Server .................................................................................. 2832
23.5.2. Debugging a MySQL Client ................................................................................... 2837
23.5.3. The DBUG Package ............................................................................................ 2837
24. MySQL Enterprise Monitor ........................................................................................................ 2839
25. MySQL Enterprise Backup ........................................................................................................ 2840
26. MySQL Workbench ................................................................................................................. 2841
A. Licenses for Third-Party Components ............................................................................................. 2842
A.1. Ant-Contrib License ....................................................................................................... 2844
A.2. ANTLR 3.3 License ....................................................................................................... 2845
A.3. Boost Library License ..................................................................................................... 2845
A.4. dtoa.c License ........................................................................................................... 2845
A.5. Editline Library (libedit) License ................................................................................... 2846
A.6. FindGTest.cmake License ........................................................................................... 2847
A.7. Fred Fish's Dbug Library License ....................................................................................... 2848
A.8. getarg License ........................................................................................................... 2849
A.9. GLib License (for MySQL Proxy) ....................................................................................... 2849
A.10. GNU General Public License Version 2.0, June 1991 ............................................................... 2849
A.11. GNU Lesser General Public License Version 2.1, February 1999 ................................................. 2853
A.12. GNU Libtool License .................................................................................................... 2859
A.13. GNU Readline License .................................................................................................. 2859
A.14. Google Controlling Master Thread I/O Rate Patch License ........................................................ 2860
A.15. Google Perftools (TCMalloc utility) License ......................................................................... 2860
A.16. Google SMP Patch License ............................................................................................. 2860
A.17. lib_sql.cc License .................................................................................................. 2861
A.18. Libaio License ............................................................................................................ 2861
A.19. libevent License ...................................................................................................... 2861
A.20. Libiconv License ......................................................................................................... 2863
MySQL 5.5 Reference Manual
xvii
A.21. libintl License ........................................................................................................ 2863
A.22. Linux-PAM License ...................................................................................................... 2863
A.23. LPeg Library License ................................................................................................... 2864
A.24. Lua (liblua) License ...................................................................................................... 2864
A.25. LuaFileSystem Library License ................................................................................... 2864
A.26. md5 (Message-Digest Algorithm 5) License ......................................................................... 2865
A.27. nt_servc (Windows NT Service class library) License .............................................................. 2865
A.28. OpenPAM License ....................................................................................................... 2865
A.29. PCRE License ............................................................................................................. 2866
A.30. Percona Multiple I/O Threads Patch License ......................................................................... 2867
A.31. RegEX-Spencer Library License ....................................................................................... 2867
A.32. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License ........................................................ 2867
A.33. Richard A. O'Keefe String Library License ........................................................................... 2868
A.34. SHA-1 in C License ...................................................................................................... 2868
A.35. Simple Logging Facade for Java (SLF4J) License ................................................................... 2868
A.36. zlib License ............................................................................................................. 2869
A.37. ZLIB.NET License ....................................................................................................... 2869
B. MySQL 5.5 Frequently Asked Questions ......................................................................................... 2870
B.1. MySQL 5.5 FAQ: General ................................................................................................ 2870
B.2. MySQL 5.5 FAQ: Storage Engines ...................................................................................... 2872
B.3. MySQL 5.5 FAQ: Server SQL Mode ................................................................................... 2872
B.4. MySQL 5.5 FAQ: Stored Procedures and Functions .................................................................. 2873
B.5. MySQL 5.5 FAQ: Triggers ............................................................................................... 2876
B.6. MySQL 5.5 FAQ: Views .................................................................................................. 2878
B.7. MySQL 5.5 FAQ: INFORMATION_SCHEMA ......................................................................... 2879
B.8. MySQL 5.5 FAQ: Migration ............................................................................................. 2880
B.9. MySQL 5.5 FAQ: Security ............................................................................................... 2880
B.10. MySQL FAQ: MySQL 5.5 and MySQL Cluster ..................................................................... 2881
B.11. MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets ...................................... 2890
B.12. MySQL 5.5 FAQ: Connectors & APIs ................................................................................ 2900
B.13. MySQL 5.5 FAQ: Replication .......................................................................................... 2900
B.14. MySQL 5.5 FAQ: MySQL, DRBD, and Heartbeat .................................................................. 2903
B.14.1. Distributed Replicated Block Device (DRBD) ............................................................. 2903
B.14.2. Linux Heartbeat ................................................................................................. 2904
B.14.3. DRBD Architecture ............................................................................................ 2904
B.14.4. DRBD and MySQL Replication .............................................................................. 2905
B.14.5. DRBD and File Systems ....................................................................................... 2906
B.14.6. DRBD and LVM ............................................................................................... 2907
B.14.7. DRBD and Virtualization ..................................................................................... 2907
B.14.8. DRBD and Security ............................................................................................ 2907
B.14.9. DRBD and System Requirements ............................................................................ 2908
B.14.10. DRBD and Support and Consulting ........................................................................ 2909
C. Errors, Error Codes, and Common Problems ..................................................................................... 2911
C.1. Sources of Error Information ............................................................................................. 2911
C.2. Types of Error Values ..................................................................................................... 2911
C.3. Server Error Codes and Messages ....................................................................................... 2912
C.4. Client Error Codes and Messages ........................................................................................ 2954
C.5. Problems and Common Errors ........................................................................................... 2957
C.5.1. How to Determine What Is Causing a Problem .............................................................. 2957
C.5.2. Common Errors When Using MySQL Programs ............................................................ 2958
C.5.3. Installation-Related Issues ...................................................................................... 2969
C.5.4. Administration-Related Issues ................................................................................. 2969
C.5.5. Query-Related Issues ............................................................................................ 2974
C.5.6. Optimizer-Related Issues ....................................................................................... 2980
C.5.7. Table Definition-Related Issues ................................................................................ 2980
C.5.8. Known Issues in MySQL ....................................................................................... 2981
D. MySQL Change History ............................................................................................................. 2984
D.1. Changes in Release 5.5.x (Production) .................................................................................. 2985
D.1.1. Changes in MySQL 5.5.24 (Not yet released) ............................................................... 2986
D.1.2. Changes in MySQL 5.5.23 (12 April 2012) .................................................................. 2986
D.1.3. Changes in MySQL 5.5.22 (21 March 2012) ................................................................ 2987
D.1.4. Changes in MySQL 5.5.21 (17 February 2012) ............................................................. 2989
D.1.5. Changes in MySQL 5.5.20 (10 January 2012) ............................................................... 2991
D.1.6. Changes in MySQL 5.5.19 (08 December 2011) ............................................................ 2992
D.1.7. Changes in MySQL 5.5.18 (16 November 2011) ........................................................... 2993
D.1.8. Changes in MySQL 5.5.17 (19 October 2011) .............................................................. 2994
D.1.9. Changes in MySQL 5.5.16 (15 September 2011) ........................................................... 2995
D.1.10. Changes in MySQL 5.5.15 (28 July 2011) .................................................................. 2997
D.1.11. Changes in MySQL 5.5.14 (05 July 2011) .................................................................. 2999
D.1.12. Changes in MySQL 5.5.13 (31 May 2011) ................................................................. 2999
MySQL 5.5 Reference Manual
xviii
D.1.13. Changes in MySQL 5.5.12 (05 May 2011) ................................................................. 3001
D.1.14. Changes in MySQL 5.5.11 (07 April 2011) ................................................................ 3002
D.1.15. Changes in MySQL 5.5.10 (15 March 2011) ............................................................... 3005
D.1.16. Changes in MySQL 5.5.9 (07 February 2011) ............................................................. 3007
D.1.17. Changes in MySQL 5.5.8 (03 December 2010, General Availability) .................................. 3012
D.1.18. Changes in MySQL 5.5.7 (14 October 2010) .............................................................. 3017
D.1.19. Changes in MySQL 5.5.6 (13 September 2010, Release Candidate) .................................... 3025
D.1.20. Changes in MySQL 5.5.5 (06 July 2010) ................................................................... 3034
D.1.21. Changes in MySQL 5.5.4 (09 April 2010) .................................................................. 3045
D.1.22. Changes in MySQL 5.5.3 (24 March 2010, Milestone 3) ................................................. 3046
D.1.23. Changes in MySQL 5.5.2 (12 February 2010) ............................................................. 3065
D.1.24. Changes in MySQL 5.5.1 (04 January 2010) ............................................................... 3068
D.1.25. Changes in MySQL 5.5.0 (07 December 2009, Milestone 2) ............................................ 3073
D.2. MySQL Connector/ODBC (MyODBC) Change History ............................................................. 3088
D.2.1. Changes in MySQL Connector/ODBC Version 5.1.x ...................................................... 3088
D.2.2. Changes in MySQL Connector/ODBC Version 5.0.x ...................................................... 3097
D.2.3. Changes in MySQL Connector/ODBC Version 3.51.x ..................................................... 3102
D.3. MySQL Connector/Net Change History ................................................................................ 3111
D.3.1. Changes in MySQL Connector/Net Version 6.5.x .......................................................... 3111
D.3.2. Changes in MySQL Connector/Net Version 6.4.x .......................................................... 3113
D.3.3. Changes in MySQL Connector/Net Version 6.3.x .......................................................... 3114
D.3.4. Changes in MySQL Connector/Net Version 6.2.x .......................................................... 3124
D.3.5. Changes in MySQL Connector/Net Version 6.1.x .......................................................... 3131
D.3.6. Changes in MySQL Connector/Net Version 6.0.x .......................................................... 3140
D.3.7. Changes in MySQL Connector/Net Version 5.3.x .......................................................... 3151
D.3.8. Changes in MySQL Connector/Net Version 5.2.x .......................................................... 3151
D.3.9. Changes in MySQL Connector/Net Version 5.1.x .......................................................... 3159
D.3.10. Changes in MySQL Connector/Net Version 5.0.x ......................................................... 3164
D.3.11. Changes in MySQL Connector/Net Version 1.0.x ......................................................... 3170
D.3.12. Changes in MySQL Connector/Net Version 0.9.0 (30 August 2004) ................................... 3177
D.3.13. Changes in MySQL Connector/Net Version 0.76 ......................................................... 3180
D.3.14. Changes in MySQL Connector/Net Version 0.75 ......................................................... 3181
D.3.15. Changes in MySQL Connector/Net Version 0.74 ......................................................... 3181
D.3.16. Changes in MySQL Connector/Net Version 0.71 ......................................................... 3183
D.3.17. Changes in MySQL Connector/Net Version 0.70 ......................................................... 3183
D.3.18. Changes in MySQL Connector/Net Version 0.68 ......................................................... 3185
D.3.19. Changes in MySQL Connector/Net Version 0.65 ......................................................... 3185
D.3.20. Changes in MySQL Connector/Net Version 0.60 ......................................................... 3185
D.3.21. Changes in MySQL Connector/Net Version 0.50 ......................................................... 3186
D.4. MySQL Visual Studio Plugin Change History ......................................................................... 3186
D.4.1. Changes in MySQL Visual Studio Plugin 1.0.3 (Not yet released) ....................................... 3186
D.4.2. Changes in MySQL Visual Studio Plugin 1.0.2 (Not yet released) ....................................... 3186
D.4.3. Changes in MySQL Visual Studio Plugin 1.0.1 (04 October 2006) ...................................... 3186
D.4.4. Changes in MySQL Visual Studio Plugin 1.0.0 (04 October 2006) ...................................... 3186
D.5. MySQL Connector/J Change History ................................................................................... 3187
D.5.1. Changes in MySQL Connector/J 5.1.x ........................................................................ 3187
D.5.2. Changes in MySQL Connector/J 5.0.x ........................................................................ 3206
D.5.3. Changes in MySQL Connector/J 3.1.x ........................................................................ 3215
D.5.4. Changes in MySQL Connector/J 3.0.x ........................................................................ 3232
D.5.5. Changes in MySQL Connector/J 2.0.x ........................................................................ 3243
D.5.6. Changes in MySQL Connector/J 1.2.x and lower ........................................................... 3247
D.6. MySQL Connector/MXJ Change History .............................................................................. 3251
D.6.1. Changes in MySQL Connector/MXJ 5.0.12 (07 July 2011) ............................................... 3251
D.6.2. Changes in MySQL Connector/MXJ 5.0.11 (24 November 2009) ....................................... 3251
D.6.3. Changes in MySQL Connector/MXJ 5.0.10 (Not released) ............................................... 3252
D.6.4. Changes in MySQL Connector/MXJ 5.0.9 (19 August 2008) ............................................. 3252
D.6.5. Changes in MySQL Connector/MXJ 5.0.8 (06 August 2007) ............................................. 3252
D.6.6. Changes in MySQL Connector/MXJ 5.0.7 (27 May 2007) ................................................ 3252
D.6.7. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007) ................................................ 3253
D.6.8. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007) .............................................. 3254
D.6.9. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007) ............................................ 3255
D.6.10. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006) ............................................... 3255
D.6.11. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006) ............................................... 3255
D.6.12. Changes in MySQL Connector/MXJ 5.0.1 (Not released) ............................................... 3256
D.6.13. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005) ........................................ 3256
D.7. MySQL Connector/C++ Change History ............................................................................... 3256
D.7.1. Changes in MySQL Connector/C++ 1.1.x ................................................................... 3256
D.7.2. Changes in MySQL Connector/C++ 1.0.x ................................................................... 3257
D.8. MySQL Proxy Change History .......................................................................................... 3261
D.8.1. Changes in MySQL Proxy 0.8.2 (18 August 2011) ......................................................... 3261
MySQL 5.5 Reference Manual
xix
D.8.2. Changes in MySQL Proxy 0.8.1 (13 September 2010) ..................................................... 3262
D.8.3. Changes in MySQL Proxy 0.8.0 (21 January 2010) ........................................................ 3263
D.8.4. Changes in MySQL Proxy 0.7.2 (30 June 2009) ............................................................ 3264
D.8.5. Changes in MySQL Proxy 0.7.1 (15 May 2009) ............................................................ 3264
D.8.6. Changes in MySQL Proxy 0.7.0 (Not Released) ............................................................ 3264
D.8.7. Changes in MySQL Proxy 0.6.1 (06 February 2008) ....................................................... 3266
D.8.8. Changes in MySQL Proxy 0.6.0 (11 September 2007) ..................................................... 3266
D.8.9. Changes in MySQL Proxy 0.5.1 (30 June 2007) ............................................................ 3267
D.8.10. Changes in MySQL Proxy 0.5.0 (19 June 2007) ........................................................... 3267
E. Restrictions and Limits .............................................................................................................. 3268
E.1. Restrictions on Stored Programs ......................................................................................... 3268
E.2. Restrictions on Condition Handling ..................................................................................... 3271
E.3. Restrictions on Server-Side Cursors ..................................................................................... 3271
E.4. Restrictions on Subqueries ................................................................................................ 3271
E.5. Restrictions on Views ...................................................................................................... 3273
E.6. Restrictions on XA Transactions ......................................................................................... 3274
E.7. Restrictions on Character Sets ............................................................................................ 3275
E.8. Restrictions on Performance Schema .................................................................................... 3275
E.9. Restrictions on Pluggable Authentication ............................................................................... 3275
E.10. Limits in MySQL ......................................................................................................... 3277
E.10.1. Limits of Joins .................................................................................................. 3277
E.10.2. Limits on Number of Databases and Tables ................................................................ 3277
E.10.3. Limits on Table Size ........................................................................................... 3277
E.10.4. Table Column-Count and Row-Size Limits ................................................................. 3278
E.10.5. Windows Platform Limitations ............................................................................... 3280
F. MySQL Glossary ..................................................................................................................... 3282
Index ....................................................................................................................................... 3348
Standard Index ............................................................................................................................ 3410
C Function Index ......................................................................................................................... 3487
Command Index .......................................................................................................................... 3494
Function Index ............................................................................................................................ 3511
INFORMATION_SCHEMA Index ...................................................................................................... 3525
Transaction Isolation Level Index ..................................................................................................... 3528
JOIN Types Index ....................................................................................................................... 3529
Operator Index ............................................................................................................................ 3530
Option Index .............................................................................................................................. 3533
Privileges Index .......................................................................................................................... 3585
SQL Modes Index ........................................................................................................................ 3589
Status Variable Index .................................................................................................................... 3591
Statement/Syntax Index ................................................................................................................. 3600
System Variable Index .................................................................................................................. 3628
MySQL 5.5 Reference Manual
xx
剩余3664页未读,继续阅读
2017-12-27 上传
2012-04-20 上传
2011-08-21 上传
2013-07-19 上传
2012-07-30 上传
2018-04-09 上传
2011-09-29 上传
2012-10-13 上传
点击了解资源详情
hesaer01
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 高清艺术文字图标资源,PNG和ICO格式免费下载
- mui框架HTML5应用界面组件使用示例教程
- Vue.js开发利器:chrome-vue-devtools插件解析
- 掌握ElectronBrowserJS:打造跨平台电子应用
- 前端导师教程:构建与部署社交证明页面
- Java多线程与线程安全在断点续传中的实现
- 免Root一键卸载安卓预装应用教程
- 易语言实现高级表格滚动条完美控制技巧
- 超声波测距尺的源码实现
- 数据可视化与交互:构建易用的数据界面
- 实现Discourse外聘回复自动标记的简易插件
- 链表的头插法与尾插法实现及长度计算
- Playwright与Typescript及Mocha集成:自动化UI测试实践指南
- 128x128像素线性工具图标下载集合
- 易语言安装包程序增强版:智能导入与重复库过滤
- 利用AJAX与Spotify API在Google地图中探索世界音乐排行榜
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功