没有合适的资源?快使用搜索试试~ 我知道了~
首页MySQL5.5官方参考手册:包含MySQL Cluster NDB 7.2
MySQL5.5官方参考手册:包含MySQL Cluster NDB 7.2
需积分: 9 5 下载量 67 浏览量
更新于2024-07-29
收藏 33.48MB PDF 举报
“MySQL5.5最新版官方手册”
MySQL 5.5 Reference Manual 是一份全面的文档,旨在帮助MySQL爱好者和专业人士自学MySQL 5.5的相关知识,包括MySQL Cluster NDB 7.2的参考指南。手册覆盖了从5.5.21版本到基于NDB CLUSTER 7.2.4的5.5.17-ndb-7.2.4的所有内容。值得注意的是,手册中描述的一些特性可能并非在所有版本的MySQL 5.5中都包含,具体的特性分布可能会根据你的许可证协议有所不同。如果你对许可证中包含的特性有疑问,应查看你的协议详情或联系Oracle的销售代表。
手册分为多个部分,以满足不同类型的用户需求:
1. **Getting Started**:这部分为初学者提供了入门指导,包括安装过程、基本概念和操作,帮助新用户快速熟悉MySQL环境。
2. **Platforms**:涵盖了MySQL在各种操作系统上的支持情况,如Linux/Unix和Mac OS X等,提供了平台特定的安装和配置指南。
3. **Administrators**:针对系统管理员,详细介绍了服务器选项、变量参考以及服务器的管理和维护技巧,包括性能优化和安全设置。
4. **Developers**:为开发人员提供了SQL语法、连接器和数据库设计的指导,如Connector/J,这是用于Java应用程序的MySQL驱动程序。
5. **Functionality**:这部分详细阐述了MySQL 5.5的各种功能,如视图、存储过程,以及高可用性和可扩展性(HA/Scalability)方面的内容。
6. **Connectors**:介绍了不同编程语言与MySQL交互的连接器,使开发者能够更好地集成MySQL到他们的应用中。
7. **HA/Scalability Guide**:提供了关于高可用性集群和扩展性的详细信息,包括MySQL Cluster,这对于需要高可靠性和高性能的大型应用至关重要。
8. **Change History**:记录了MySQL 5.5自发布以来的更新历史,方便用户跟踪版本变更和修复。
9. **Views and Stored Programs**:这部分深入探讨了数据库中的视图创建和管理,以及存储过程的编写和执行,这些都是数据库开发中的高级特性。
10. **Installation**:提供了详细的安装步骤,帮助用户在各自的平台上正确地安装MySQL 5.5。
通过这份手册,读者可以全面了解MySQL 5.5的功能,掌握数据库的管理、查询优化、开发接口的使用,以及如何构建高可用性和可扩展性的解决方案。对于任何希望深入了解MySQL 5.5的用户来说,这是一份不可或缺的参考资料。
21.2.6. Connector/Net Connection String Options Reference ..................................................... 2156
21.2.7. Connector/Net API Reference ................................................................................. 2159
21.2.8. Connector/Net Support ......................................................................................... 2253
21.2.9. Connector/Net FAQ ............................................................................................ 2254
21.3. MySQL Connector/J ...................................................................................................... 2255
21.3.1. Connector/J Versions ........................................................................................... 2256
21.3.2. Connector/J Installation ........................................................................................ 2257
21.3.3. Connector/J Examples .......................................................................................... 2261
21.3.4. Connector/J (JDBC) Reference ............................................................................... 2261
21.3.5. Connector/J Notes and Tips ................................................................................... 2291
21.3.6. Connector/J Support ............................................................................................ 2321
21.4. MySQL Connector/MXJ ................................................................................................. 2322
21.4.1. Connector/MXJ Overview ..................................................................................... 2322
21.4.2. Connector/MXJ Versions ...................................................................................... 2323
21.4.3. Connector/MXJ Installation ................................................................................... 2324
21.4.4. Connector/MXJ Configuration ................................................................................ 2328
21.4.5. Connector/MXJ Reference ..................................................................................... 2330
21.4.6. Connector/MXJ Notes and Tips ............................................................................... 2331
21.4.7. Connector/MXJ Samples ....................................................................................... 2335
21.4.8. Connector/MXJ Support ....................................................................................... 2338
21.5. MySQL Connector/C++ .................................................................................................. 2339
21.5.1. MySQL Connector/C++ Binary Installation ................................................................ 2341
21.5.2. MySQL Connector/C++ Source Installation ................................................................ 2345
21.5.3. MySQL Connector/C++ Building Windows applications with Microsoft Visual Studio ............. 2349
21.5.4. MySQL Connector/C++ Building Linux applications with NetBeans ................................... 2361
21.5.5. MySQL Connector/C++ Getting Started: Usage Examples ............................................... 2366
21.5.6. MySQL Connector/C++ Tutorials ............................................................................ 2371
21.5.7. MySQL Connector/C++ Debug Tracing ..................................................................... 2377
21.5.8. MySQL Connector/C++ Usage Notes ....................................................................... 2378
21.5.9. MySQL Connector/C++ Known Bugs and Issues .......................................................... 2381
21.5.10. MySQL Connector/C++ Feature requests .................................................................. 2381
21.5.11. MySQL Connector/C++ Support ............................................................................ 2382
21.5.12. MySQL Connector/C++ FAQ ............................................................................... 2382
21.6. MySQL Connector/C ..................................................................................................... 2382
21.6.1. Building MySQL Connector/C from the Source Code .................................................... 2383
21.6.2. Testing MySQL Connector/C ................................................................................. 2385
21.6.3. MySQL Connector/C FAQ .................................................................................... 2385
21.7. MySQL Connector/OpenOffice.org .................................................................................... 2386
21.7.1. Installation ....................................................................................................... 2386
21.7.2. Getting Started: Connecting to MySQL ..................................................................... 2387
21.7.3. Getting Started: Usage Examples ............................................................................. 2392
21.7.4. References ....................................................................................................... 2392
21.7.5. Known Bugs ..................................................................................................... 2392
21.7.6. Contact ........................................................................................................... 2392
21.8. libmysqld, the Embedded MySQL Server Library ................................................................... 2392
21.8.1. Compiling Programs with libmysqld ..................................................................... 2393
21.8.2. Restrictions When Using the Embedded MySQL Server ................................................. 2393
21.8.3. Options with the Embedded Server ........................................................................... 2394
21.8.4. Embedded Server Examples ................................................................................... 2394
21.8.5. Licensing the Embedded Server .............................................................................. 2396
21.9. MySQL C API ............................................................................................................. 2396
21.9.1. C API Data Structures .......................................................................................... 2397
21.9.2. C API Function Overview ..................................................................................... 2401
21.9.3. C API Function Descriptions .................................................................................. 2404
21.9.4. C API Prepared Statements .................................................................................... 2445
21.9.5. C API Prepared Statement Data Structures .................................................................. 2446
21.9.6. C API Prepared Statement Function Overview ............................................................. 2451
21.9.7. C API Prepared Statement Function Descriptions .......................................................... 2453
21.9.8. C API Threaded Function Descriptions ...................................................................... 2472
21.9.9. C API Embedded Server Function Descriptions ............................................................ 2473
21.9.10. C API Client Plugin Functions .............................................................................. 2474
21.9.11. Common Questions and Problems When Using the C API .............................................. 2476
21.9.12. Controlling Automatic Reconnection Behavior ........................................................... 2478
21.9.13. C API Support for Multiple Statement Execution ........................................................ 2479
21.9.14. C API Prepared Statement Problems ....................................................................... 2480
21.9.15. C API Prepared Statement Handling of Date and Time Values ......................................... 2481
21.9.16. C API Support for Prepared CALL Statements ............................................................ 2482
21.9.17. Building Client Programs .................................................................................... 2485
21.10. MySQL PHP API ........................................................................................................ 2487
21.10.1. Original MySQL API (Mysql) ............................................................................. 2487
MySQL 5.5 Reference Manual
xvi
21.10.2. MySQL Improved Extension (Mysqli) ................................................................... 2543
21.10.3. MySQL Native Driver (Mysqlnd) ......................................................................... 2704
21.10.4. MySQL Functions (PDO_MYSQL) (MySQL (PDO)) .................................................. 2742
21.10.5. Connector/PHP ................................................................................................ 2745
21.10.6. Common Problems with MySQL and PHP ................................................................ 2745
21.10.7. Enabling Both mysql and mysqli in PHP .............................................................. 2745
21.11. MySQL Perl API ......................................................................................................... 2745
21.12. MySQL Python API ..................................................................................................... 2746
21.13. MySQL Ruby APIs ...................................................................................................... 2746
21.13.1. The MySQL/Ruby API ....................................................................................... 2746
21.13.2. The Ruby/MySQL API ....................................................................................... 2746
21.14. MySQL Tcl API ......................................................................................................... 2746
21.15. MySQL Eiffel Wrapper ................................................................................................. 2746
22. Extending MySQL .................................................................................................................. 2747
22.1. MySQL Internals .......................................................................................................... 2747
22.1.1. MySQL Threads ................................................................................................. 2747
22.1.2. The MySQL Test Suite ......................................................................................... 2748
22.2. The MySQL Plugin API .................................................................................................. 2748
22.2.1. Plugin API Characteristics ..................................................................................... 2749
22.2.2. Plugin API Components ....................................................................................... 2750
22.2.3. Types of Plugins ................................................................................................ 2750
22.2.4. Writing Plugins .................................................................................................. 2753
22.2.5. MySQL Services for Plugins .................................................................................. 2783
22.3. Adding New Functions to MySQL ..................................................................................... 2785
22.3.1. Features of the User-Defined Function Interface ........................................................... 2785
22.3.2. Adding a New User-Defined Function ....................................................................... 2785
22.3.3. Adding a New Native Function ............................................................................... 2793
22.4. Adding New Procedures to MySQL .................................................................................... 2794
22.4.1. PROCEDURE ANALYSE ...................................................................................... 2794
22.4.2. Writing a Procedure ............................................................................................ 2795
22.5. Debugging and Porting MySQL ........................................................................................ 2795
22.5.1. Debugging a MySQL Server .................................................................................. 2796
22.5.2. Debugging a MySQL Client ................................................................................... 2801
22.5.3. The DBUG Package ............................................................................................ 2801
23. MySQL Enterprise Monitor ........................................................................................................ 2803
24. MySQL Enterprise Backup ........................................................................................................ 2804
25. MySQL Workbench ................................................................................................................. 2805
A. Licenses for Third-Party Components ............................................................................................. 2806
A.1. Ant-Contrib License ....................................................................................................... 2808
A.2. ANTLR 3.3 License ....................................................................................................... 2808
A.3. Boost Library License ..................................................................................................... 2809
A.4. dtoa.c License ........................................................................................................... 2809
A.5. Editline Library (libedit) License ................................................................................... 2809
A.6. FindGTest.cmake License ........................................................................................... 2811
A.7. Fred Fish's Dbug Library License ....................................................................................... 2812
A.8. getarg License ........................................................................................................... 2812
A.9. GLib License (for MySQL Proxy) ....................................................................................... 2813
A.10. GNU General Public License Version 2.0, June 1991 ............................................................... 2813
A.11. GNU Lesser General Public License Version 2.1, February 1999 ................................................. 2817
A.12. GNU Libtool License .................................................................................................... 2822
A.13. GNU Readline License .................................................................................................. 2823
A.14. Google Controlling Master Thread I/O Rate Patch License ........................................................ 2823
A.15. Google Perftools (TCMalloc utility) License ......................................................................... 2824
A.16. Google SMP Patch License ............................................................................................. 2824
A.17. lib_sql.cc License .................................................................................................. 2825
A.18. libevent License ...................................................................................................... 2825
A.19. Linux-PAM License ...................................................................................................... 2826
A.20. LPeg Library License ................................................................................................... 2827
A.21. Lua (liblua) License ...................................................................................................... 2827
A.22. LuaFileSystem Library License ................................................................................... 2827
A.23. md5 (Message-Digest Algorithm 5) License ......................................................................... 2828
A.24. nt_servc (Windows NT Service class library) License .............................................................. 2828
A.25. OpenPAM License ....................................................................................................... 2828
A.26. PCRE License ............................................................................................................. 2829
A.27. Percona Multiple I/O Threads Patch License ......................................................................... 2829
A.28. RegEX-Spencer Library License ....................................................................................... 2830
A.29. RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License ........................................................ 2830
A.30. Richard A. O'Keefe String Library License ........................................................................... 2831
A.31. SHA-1 in C License ...................................................................................................... 2831
A.32. Simple Logging Facade for Java (SLF4J) License ................................................................... 2831
MySQL 5.5 Reference Manual
xvii
A.33. zlib License ............................................................................................................. 2832
A.34. ZLIB.NET License ....................................................................................................... 2832
B. MySQL 5.5 Frequently Asked Questions ......................................................................................... 2833
B.1. MySQL 5.5 FAQ: General ................................................................................................ 2833
B.2. MySQL 5.5 FAQ: Storage Engines ...................................................................................... 2835
B.3. MySQL 5.5 FAQ: Server SQL Mode ................................................................................... 2835
B.4. MySQL 5.5 FAQ: Stored Procedures and Functions .................................................................. 2836
B.5. MySQL 5.5 FAQ: Triggers ............................................................................................... 2839
B.6. MySQL 5.5 FAQ: Views .................................................................................................. 2841
B.7. MySQL 5.5 FAQ: INFORMATION_SCHEMA ......................................................................... 2842
B.8. MySQL 5.5 FAQ: Migration ............................................................................................. 2843
B.9. MySQL 5.5 FAQ: Security ............................................................................................... 2843
B.10. MySQL FAQ: MySQL 5.5 and MySQL Cluster ..................................................................... 2844
B.11. MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets ...................................... 2853
B.12. MySQL 5.5 FAQ: Connectors & APIs ................................................................................ 2863
B.13. MySQL 5.5 FAQ: Replication .......................................................................................... 2863
B.14. MySQL 5.5 FAQ: MySQL, DRBD, and Heartbeat .................................................................. 2866
B.14.1. Distributed Replicated Block Device (DRBD) ............................................................. 2866
B.14.2. Linux Heartbeat ................................................................................................. 2867
B.14.3. DRBD Architecture ............................................................................................ 2867
B.14.4. DRBD and MySQL Replication .............................................................................. 2868
B.14.5. DRBD and File Systems ....................................................................................... 2869
B.14.6. DRBD and LVM ............................................................................................... 2870
B.14.7. DRBD and Virtualization ..................................................................................... 2870
B.14.8. DRBD and Security ............................................................................................ 2870
B.14.9. DRBD and System Requirements ............................................................................ 2871
B.14.10. DRBD and Support and Consulting ........................................................................ 2872
C. Errors, Error Codes, and Common Problems ..................................................................................... 2874
C.1. Sources of Error Information ............................................................................................. 2874
C.2. Types of Error Values ..................................................................................................... 2874
C.3. Server Error Codes and Messages ....................................................................................... 2875
C.4. Client Error Codes and Messages ........................................................................................ 2916
C.5. Problems and Common Errors ........................................................................................... 2920
C.5.1. How to Determine What Is Causing a Problem .............................................................. 2920
C.5.2. Common Errors When Using MySQL Programs ............................................................ 2921
C.5.3. Installation-Related Issues ...................................................................................... 2931
C.5.4. Administration-Related Issues ................................................................................. 2931
C.5.5. Query-Related Issues ............................................................................................ 2937
C.5.6. Optimizer-Related Issues ....................................................................................... 2942
C.5.7. Table Definition-Related Issues ................................................................................ 2943
C.5.8. Known Issues in MySQL ....................................................................................... 2944
D. MySQL Change History ............................................................................................................. 2947
D.1. Changes in Release 5.5.x (Production) .................................................................................. 2948
D.1.1. Changes in MySQL 5.5.21 (Not yet released) ............................................................... 2949
D.1.2. Changes in MySQL 5.5.20 (10 January 2012) ............................................................... 2949
D.1.3. Changes in MySQL 5.5.19 (08 December 2011) ............................................................ 2950
D.1.4. Changes in MySQL 5.5.18 (16 November 2011) ........................................................... 2950
D.1.5. Changes in MySQL 5.5.17 (19 October 2011) .............................................................. 2951
D.1.6. Changes in MySQL 5.5.16 (15 September 2011) ........................................................... 2952
D.1.7. Changes in MySQL 5.5.15 (28 July 2011) ................................................................... 2954
D.1.8. Changes in MySQL 5.5.14 (05 July 2011) ................................................................... 2956
D.1.9. Changes in MySQL 5.5.13 (31 May 2011) ................................................................... 2957
D.1.10. Changes in MySQL 5.5.12 (05 May 2011) ................................................................. 2958
D.1.11. Changes in MySQL 5.5.11 (07 April 2011) ................................................................ 2959
D.1.12. Changes in MySQL 5.5.10 (15 March 2011) ............................................................... 2962
D.1.13. Changes in MySQL 5.5.9 (07 February 2011) ............................................................. 2964
D.1.14. Changes in MySQL 5.5.8 (03 December 2010 General Availability) .................................. 2969
D.1.15. Changes in MySQL 5.5.7 (14 October 2010) .............................................................. 2974
D.1.16. Changes in MySQL 5.5.6 (13 September 2010 Release Candidate) .................................... 2981
D.1.17. Changes in MySQL 5.5.5 (06 July 2010) ................................................................... 2990
D.1.18. Changes in MySQL 5.5.4 (09 April 2010) .................................................................. 3002
D.1.19. Changes in MySQL 5.5.3 (24 March 2010 Milestone 3) ................................................. 3003
D.1.20. Changes in MySQL 5.5.2 (12 February 2010) ............................................................. 3022
D.1.21. Changes in MySQL 5.5.1 (04 January 2010) ............................................................... 3025
D.1.22. Changes in MySQL 5.5.0 (07 December 2009 Milestone 2) ............................................. 3029
D.2. MySQL Connector/ODBC (MyODBC) Change History ............................................................. 3044
D.2.1. Changes in MySQL Connector/ODBC Version 5.1.x ...................................................... 3045
D.2.2. Changes in MySQL Connector/ODBC Version 5.0.x ...................................................... 3054
D.2.3. Changes in MySQL Connector/ODBC Version 3.51.x ..................................................... 3058
D.3. MySQL Connector/Net Change History ................................................................................ 3067
MySQL 5.5 Reference Manual
xviii
D.3.1. Changes in MySQL Connector/Net Version 6.5.x .......................................................... 3067
D.3.2. Changes in MySQL Connector/Net Version 6.4.x .......................................................... 3067
D.3.3. Changes in MySQL Connector/Net Version 6.3.x .......................................................... 3068
D.3.4. Changes in MySQL Connector/Net Version 6.2.x .......................................................... 3076
D.3.5. Changes in MySQL Connector/Net Version 6.1.x .......................................................... 3084
D.3.6. Changes in MySQL Connector/Net Version 6.0.x .......................................................... 3093
D.3.7. Changes in MySQL Connector/Net Version 5.3.x .......................................................... 3103
D.3.8. Changes in MySQL Connector/Net Version 5.2.x .......................................................... 3103
D.3.9. Changes in MySQL Connector/Net Version 5.1.x .......................................................... 3112
D.3.10. Changes in MySQL Connector/Net Version 5.0.x ......................................................... 3116
D.3.11. Changes in MySQL Connector/Net Version 1.0.x ......................................................... 3123
D.3.12. Changes in MySQL Connector/Net Version 0.9.0 (30 August 2004) ................................... 3130
D.3.13. Changes in MySQL Connector/Net Version 0.76 ......................................................... 3133
D.3.14. Changes in MySQL Connector/Net Version 0.75 ......................................................... 3133
D.3.15. Changes in MySQL Connector/Net Version 0.74 ......................................................... 3134
D.3.16. Changes in MySQL Connector/Net Version 0.71 ......................................................... 3135
D.3.17. Changes in MySQL Connector/Net Version 0.70 ......................................................... 3136
D.3.18. Changes in MySQL Connector/Net Version 0.68 ......................................................... 3137
D.3.19. Changes in MySQL Connector/Net Version 0.65 ......................................................... 3138
D.3.20. Changes in MySQL Connector/Net Version 0.60 ......................................................... 3138
D.3.21. Changes in MySQL Connector/Net Version 0.50 ......................................................... 3138
D.4. MySQL Visual Studio Plugin Change History ......................................................................... 3138
D.4.1. Changes in MySQL Visual Studio Plugin 1.0.3 (Not yet released) ....................................... 3138
D.4.2. Changes in MySQL Visual Studio Plugin 1.0.2 (Not yet released) ....................................... 3138
D.4.3. Changes in MySQL Visual Studio Plugin 1.0.1 (04 October 2006) ...................................... 3139
D.4.4. Changes in MySQL Visual Studio Plugin 1.0.0 (04 October 2006) ...................................... 3139
D.5. MySQL Connector/J Change History ................................................................................... 3139
D.5.1. Changes in MySQL Connector/J 5.1.x ........................................................................ 3139
D.5.2. Changes in MySQL Connector/J 5.0.x ........................................................................ 3158
D.5.3. Changes in MySQL Connector/J 3.1.x ........................................................................ 3167
D.5.4. Changes in MySQL Connector/J 3.0.x ........................................................................ 3183
D.5.5. Changes in MySQL Connector/J 2.0.x ........................................................................ 3194
D.5.6. Changes in MySQL Connector/J 1.2.x and lower ........................................................... 3199
D.6. MySQL Connector/MXJ Change History .............................................................................. 3202
D.6.1. Changes in MySQL Connector/MXJ 5.0.12 (07 July 2011) ............................................... 3203
D.6.2. Changes in MySQL Connector/MXJ 5.0.11 (24 November 2009) ....................................... 3203
D.6.3. Changes in MySQL Connector/MXJ 5.0.10 (Not released) ............................................... 3203
D.6.4. Changes in MySQL Connector/MXJ 5.0.9 (19 August 2008) ............................................. 3203
D.6.5. Changes in MySQL Connector/MXJ 5.0.8 (06 August 2007) ............................................. 3204
D.6.6. Changes in MySQL Connector/MXJ 5.0.7 (27 May 2007) ................................................ 3204
D.6.7. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007) ................................................ 3204
D.6.8. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007) .............................................. 3205
D.6.9. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007) ............................................ 3206
D.6.10. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006) ............................................... 3207
D.6.11. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006) ............................................... 3207
D.6.12. Changes in MySQL Connector/MXJ 5.0.1 (Not released) ............................................... 3208
D.6.13. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005) ........................................ 3208
D.7. MySQL Connector/C++ Change History ............................................................................... 3208
D.7.1. Changes in MySQL Connector/C++ 1.1.x ................................................................... 3208
D.7.2. Changes in MySQL Connector/C++ 1.0.x ................................................................... 3209
D.8. MySQL Proxy Change History .......................................................................................... 3213
D.8.1. Changes in MySQL Proxy 0.8.2 (18 August 2011) ......................................................... 3213
D.8.2. Changes in MySQL Proxy 0.8.1 (13 September 2010) ..................................................... 3214
D.8.3. Changes in MySQL Proxy 0.8.0 (21 January 2010) ........................................................ 3214
D.8.4. Changes in MySQL Proxy 0.7.2 (30 June 2009) ............................................................ 3215
D.8.5. Changes in MySQL Proxy 0.7.1 (15 May 2009) ............................................................ 3215
D.8.6. Changes in MySQL Proxy 0.7.0 (Not Released) ............................................................ 3216
D.8.7. Changes in MySQL Proxy 0.6.1 (06 February 2008) ....................................................... 3217
D.8.8. Changes in MySQL Proxy 0.6.0 (11 September 2007) ..................................................... 3217
D.8.9. Changes in MySQL Proxy 0.5.1 (30 June 2007) ............................................................ 3218
D.8.10. Changes in MySQL Proxy 0.5.0 (19 June 2007) ........................................................... 3219
E. Restrictions and Limits .............................................................................................................. 3220
E.1. Restrictions on Stored Programs ......................................................................................... 3220
E.2. Restrictions on Condition Handling ..................................................................................... 3223
E.3. Restrictions on Server-Side Cursors ..................................................................................... 3223
E.4. Restrictions on Subqueries ................................................................................................ 3223
E.5. Restrictions on Views ...................................................................................................... 3226
E.6. Restrictions on XA Transactions ......................................................................................... 3227
E.7. Restrictions on Character Sets ............................................................................................ 3227
E.8. Restrictions on Performance Schema .................................................................................... 3228
MySQL 5.5 Reference Manual
xix
E.9. Restrictions on Pluggable Authentication ............................................................................... 3228
E.10. Limits in MySQL ......................................................................................................... 3230
E.10.1. Limits of Joins .................................................................................................. 3230
E.10.2. Limits on Number of Databases and Tables ................................................................ 3230
E.10.3. Limits on Table Size ........................................................................................... 3230
E.10.4. Table Column-Count and Row-Size Limits ................................................................. 3231
E.10.5. Windows Platform Limitations ............................................................................... 3233
Index ....................................................................................................................................... 3235
Standard Index ............................................................................................................................ 3294
C Function Index ......................................................................................................................... 3377
Command Index .......................................................................................................................... 3384
Function Index ............................................................................................................................ 3408
INFORMATION_SCHEMA Index ...................................................................................................... 3430
Transaction Isolation Level Index ..................................................................................................... 3433
JOIN Types Index ....................................................................................................................... 3434
Operator Index ............................................................................................................................ 3435
Option Index .............................................................................................................................. 3439
Privileges Index .......................................................................................................................... 3507
SQL Modes Index ........................................................................................................................ 3511
Status Variable Index .................................................................................................................... 3513
Statement/Syntax Index ................................................................................................................. 3522
System Variable Index .................................................................................................................. 3553
MySQL 5.5 Reference Manual
xx
剩余3592页未读,继续阅读
162 浏览量
点击了解资源详情
107 浏览量
2011-08-15 上传
413 浏览量
点击了解资源详情
点击了解资源详情
点击了解资源详情
点击了解资源详情
kasonbin
- 粉丝: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Bilibili尚硅谷Java教学:深入解析BIO与NIO
- DFColorGen: 为矮人要塞打造颜色生成器
- HarmonyOS 2实现discord客户端与IRC守护进程的可靠集成
- Python第三方库:kia_uvo_hyundai_bluelink-0.1.0介绍
- node-v8.12.0-x64纯净版:64位Windows系统JS编辑工具
- JSP论坛系统Web开发实战项目源码分享
- Interactor Rails:为Rails应用提供Interactor模式支持
- Arduino简易LCD控制菜单的构建指南
- node-dpfb: 浏览器指纹采集与识别技术解析
- 深入解析Wordpress PasswordHash类及其在Java中的应用
- 前端下拉列表库-tether-drop客户端项目
- 解决JDK1.8以上版本访问Access数据库的限制问题
- JavaWeb课程S2结业项目-图书管理系统
- Java基础数据类型及类型转换教程
- Java开发实践:深入探讨E41201367_Fauzan-Abdillah_C项目
- Ruby Push Notifications:简化iOS、Android和Windows Phone推送通知的实现
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功