refman-5.7-en.a4.pdfMySQL 5.7官方参考手册包括MySQL NDB Cl

文件名称: refman-5.7-en.a4.pdf

所属分类: MySQL

开发工具:

文件大小: 39mb

下载次数: 0

上传时间: 2019-07-01

提供者: dengjin20*********

下载 (39mb)

不能下载？报告错误

详细说明：MySQL 5.7官方参考手册包括MySQL NDB Cluster 7.5和NDB Cluster 7.6 抽象这是MySQL™参考手册。它分别记录了MySQL 5.7到5.7.28，以及基于NDB5.7.27-ndb-7.5.15 版本7.5的NDB Cluster版本。它可能包括尚未发布的MySQL版本功能的文档。有关已发布的版本的信息，请参阅 MySQL 5.7发行说明。 MySQL 5.7功能。本手册介绍了每个版本的MySQL 5.7中未包含的功能; 这些功能可能不包含在许可给您的MySQL 5.7版本中。如果您对MySQL 5.7版本中包含的功能有任何疑问，请参阅MySQL 5.7许可协议或联系您的Oracle销售代表。有关详细说明每个版本中的更改的说明，请参阅 MySQL 5.7发行说明。有关法律信息（包括许可信息），请参阅前言和法律声明。有关使用MySQL的帮助，请访问 MySQL论坛，在那里您可以与其他MySQL用户讨论您的问题。文件生成于：2019-06-30（修订：62511）Table of contents Preface and Legal Notices XXV 1 General Information 1.1 About this manual 1.2 Typographical and Syntax Conventions 1.3 Overview of the My sQL Database management system 4 1.3.1 What is MySQL?… 1.3.2 The Main Features of My SQL 1.3.3 History of MySQL 1. 4 What s n MySQL 5.7 1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 5.7 ,23 1.6 MySQL Information Sources 1.6.1 My SQL Websites∴… 39 1.6.2 MySQL Mailing Lists 1.6.3 My SQL Community Support at the My SQL Forums 1.6.4 MySQL Community Support on Internet Relay Chat (IRC) 42 1.6.5 My SQL Enterprise 42 7 How to Report Bugs or Problems 1.8 My SQL Standards Compliance 1.8. 1 My SQL Extensions to Standard SQL 48 1.8.2 MySQL Differences from Standard SQL 51 1.8.3 How MySQL Deals with Constraints 52 1. 9 Credits 56 1.9.1 Contributors to MySQL 56 1.9.2 Documenters and translators b 1.9.3 Packages that support MySQL_…… 1.9.4 Tools that were used to create Mysd'. 61 62 1.9.5 Supporters of MysQL…… 62 2 Installing and Upgrading MySQL 65 2.1 General Installation guidance 67 2.1.1 Which MysQL Version and distribution to install 2.1.2 How to Get MySQL 2.1. 3 Verifying Package Integrity Using MD5 Checksums or GnuPG .69 69 2.1. 4 Installation Layouts 82 2.1.5 Compiler-Specific Build Characteristics 82 2.2 Installing MySQL on UniX/Linux Using Generic Binaries 82 2.3 Installing MysQL on Microsoft Windows 85 2.3.1 MySQL Installation Layout on Microsoft Windows 2.3.2 Choosing an Installation Package 2.3. 3 My SQL Installer for Windows 90 2.3.4 MySQL Notifier 113 2.3.5 Installing MySQL on Microsoft Windows Using a noinstalI ZIP Archive 124 2.3.6 Troubleshooting a Microsoft Windows MySQL Server Installation 133 2.3.7 Windows postinstallation procedures 134 2. 4 Installing My SQL on macOS 136 2.4.1 General Notes on Installing MysQL on macOS 37 2.4.2 Installing MySQL on macOS Using Native Packages 138 2.4.3 Installing a mysQl Launch daemon 面面面11 142 2.4.4 Installing and Using the MySQL Preference Pane 145 2.5 Installing MysQL on Linux 2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository 149 150 2.5.2 Replacing a Third-Party Distribution of My sQL Using the MysQL Yum Reposito 154 2.5.3 Installing mysQL on Linux Using the MysQL APT Repository .156 2.5. 4 Installing MysQL on Linux Using the MySQL SLES Repository 157 MySQL 5.7 Reference Manual 2.5.5 Installing MySQL on Linux Using RPM Packages from Oracle 157 2.5.6 Installing MySQL on Linux Using Debian Packages from Oracle 162 2.5.7 Deploying MySQL on Linux with Docker 163 2.5.8 Installing MySQL on Linux from the Native Software Repositories .172 2.5.9 stalling MysQL on Linux with Juju…… 175 2.5.10 Managing MySQL Server with systemd 自面面国面面面 176 2.6 Installing My SQL Using Unbreakable Linux Network (ULN) 181 2.7| stalling My SQL on Solaris......…...….……………181 2.7.1 Installing MySQL on Solaris Using a Solaris PKG... 182 2.8 Installing MySQL on FreeBSD 183 2.9 Installing MySQL from Source 184 2.9.1 My SQL Layout for Source Installation 186 2.9.2 stalling My SQL∪ sing a Standard Source Distribution………… 186 2.9.3 Installing My SQL Using a Development Source Tree 190 2.9.4 My SQL Source- Configuration Options…… 192 2.9.5 Dealing with Problems Compiling MySQL 213 2.9.6 MySQL Configuration and third-Party tools 215 2.10 Postinstallation Setup and Testing 215 2.10.1 Initializing the Data Directory 216 2.10.2 Starting the server 221 2. 10.3 Testing the Server....... 224 2. 10.4 Securing the Initial My SQL Account 226 2. 10.5 Starting and Stopping My SQL Automatically 228 2.11 Upgrading MySQL 2.11.1 Before You begin 229 2.11.2 Upgrade Paths 230 2.11.3 Changes in MySQL 5.7 230 2.11.4 Upgrading My SQL Binary or Package-based Installations on Unix/Linux 239 2.11.5 Upgrading MySQL with the MysQL Yum Repository……… 242 2.11.6 Upgrading MySQL with the MySQL APT Repository 243 2. 11.7 Upgrading MySQL with the MysQL SLES Repository 244 2. 11.8 Upgrading My SQL on Windows 2. 11.9 Upgrading a Docker Installation of MySQL .245 2. 11.10 Upgrading MySQL with Directly-Downloaded RPM Packages 245 2.11.11 Upgrade Troubleshooting………, 247 2. 11.12 Rebuilding or Repairing Tables or Indexes .247 2. 11.13 Copying MySQL Databases to Another Machine 249 2.12 Downgrading MysQl 2.12.1 Before You Begin..,....... 250 2.12.2 Downgrade paths .251 2. 12.3 Downgrade Notes 251 2. 12. 4 Downgrading Binary and Package-based Installations on Unix/Linux...... 254 2. 12.5 Downgrade Troubleshooting .256 2.13 Perl Installation notes 256 2.13. 1 Installing perl on Unix 257 2.13.2 Installing ActiveState Perl on Windows 2.13.3 Problems Using the Perl DBI/DBD Interface 258 258 3 Tutorial 261 3.1 Connecting to and Disconnecting from the Server 261 3.2 Entering Queries 262 3.3 Creating and using a database ..265 3.3.1 Creating and Selecting a Database 266 3.3.2 Creating a Table..... 3.3.3 Loading data into a table......... 268 3.3. 4 Retrieving Information from a table 270 3. 4 Getting Information About Databases and Tables 283 3.5 Using mysql in Batch Mode 284 3.6 EXamples of Common Queries 285 MySQL 5.7 Reference Manual 3.6.1 The maximum value for a column 286 3.6.2 The Row Holding the Maximum of a Certain Column. 286 3.6.3 Maximum of Column per Group ..287 3.6.4 The Rows Holding the Group-Wise Maximum of a Certain Column 87 3.6.5 Using User-Defined Variables 288 3.6.6 Using Foreign Keys. ...........................................................................,.............288 3.6.7 Searching on Two Keys 3.6.8 Calculating Visits Per Day 3.6. 9 Using AUTO INCREMENT 290 3.7 Using MySQL with Apache 293 4 MySQL Programs 4. 1 Overview of MysQL Programs 4.2 Using My SQL Programs... 300 4.2. 1 Invoking My SQL Programs 300 4.2.2 Connecting to the MySQL Server..... 301 4.2.3 Specifying Program Options .305 4.2.4 Using Options on the Command Line 4.2.5 Program Option Modifiers 4.2.6 Using Option Files 308 4.2.7 Command-Line Options that Affect Option-File Handling 312 4.2.8 Using Options to Set Program Variables 314 4.2.9 Option Defaults, Options Expecting Values, and the=Sign…………,315 4.2. 10 Setting Environment Variables 318 4.3 MySQL Server and Server-Startup Programs 319 4.3.1 myscld -The MysQL Server 319 4.3.2 mysqid safe- MysQL Server Startup Script 320 4.3.3 mysql. server- MysQL Server Startup Script..... 326 4.3. 4 mysqld multi- Manage Multiple My SQL Servers 328 4. 4 MySQL Installation-Related Programs 332 4.4.1 comp er Compile My SQL Error Message File 332 4.4.2 mysql ins=all db- Initialize My SQL Data Directory 333 4.4.3 mysqL plugin- Configure MysQL Server Plugins 4.4.4 mysql secure installaticn-Improve My SQL Installation Security .... 345 4.4.5 mysql ssl rsa setup -Create SSL/RSA Files 347 4.4.6 mysql tzinfo to sql-Load the Time Zone Tables...... ∴350 4.4.7 mysql upgrade- Check and Upgrade MysQL Tables............ 351 4.5 MySQL Client Programs 4.5. 1 mysq-- The My sQL Command-Line Client 4.5.2 nysa ladImin -Client for Administering a My SQL Server 358 4.5.3 mysqicheck-A Table Maintenance Program 394 4.5. 4 mysq-durmp -A Database Backup Program 403 4.5.5 mysqlimport-A Data Import Program 425 4.5.6 mysa- A database backup program 432 4.5.7 mysqlshow--Display Database, Table, and Column Information 448 4.5.8 mysql Load emulation client 454 4.6 MysQL Administrative and Utility Programs 463 4.6.1 innochecksum-Offline InnoDB File Checksum Utility 463 4.6.2 myisam ftaump-Display Full-Text Index information 469 4.6.3 myisamchk- Myl SAM Table-Maintenance Utility……… 470 4.6. 4 myi samlog-Display Myl SAM Log File Contents 486 4.6.5 myisampack -Generate Compressed, Read-Only myIsam Tables 487 4.6.6 mysql config editor -- MySQL Configuration Utility 493 4.6.7 nysylbinloc- Utility for Processing Binary Log Files……… 499 46.8mysq1 dumps1ow- Summarize Slow Query Log Files...……… 519 4.7 My SQL Program Development Utilities 521 4.7.1 mysql config- Display Options for Compiling Clients 522 4.7.2 my print. defaults-Display Options from Option Files 523 4.7.3 resolve stack dump -Resolve Numeric Stack Trace Dump to Symbols MySQL 5.7 Reference Manual 4.8 Miscellaneous Programs 525 4.8.1 1z4 decompress- Decompress mysqlpump LZ4-Compressed Output.... 525 4.8.2 perror- Display MysQL Error Message Information 525 4.8.3 replace -A String-Replacement Utility 526 4.8. 4 resolveip-Resolve Host name to IP Address or Vice Versa...... 527 4.8.5 zlib decompress -Decompress mysqlpump ZLIB-Compressed Output... 528 4.9 MySQL Program Environment Variables 528 5 MySQL Server Administration…… 531 5.1 The MySQL Server 532 5.1.1 Configuring the Server 532 5.1.2 Server Configuration Defaults 534 5.1.3 Server Option, System Variable, and status Variable Reference 534 5.1.4 Server System Variable Reference 576 5.1.5 Server Status Variable Reference 599 5.1.6 Server Command Options 613 5.1.7 Server System variables 650 5.1.8 Using System Variables 769 5.1.9 Server status variables 786 5.1.10 Server sQL Modes 5.1.11Pv6 Support.… 821 5. 1. 12 MySQL Server Time Zone Support 825 5.1.13 Server-Side Help Support 830 5.1. 14 Server tracking of client Session State Changes 830 5. 1.15 Server Response to Signals 83 5.1.16 The Server shutdown process 834 5.2 The My SQL Data Directory 836 5.3 The mysql System Database ..836 5. 4 My SQL Server Logs ..839 5.4.1 Selecting General Query Log and Slow Query Log Output Destinations 840 5.4.2 The error lot 842 54.3 The General Query Log…… .845 5.4.4 The Binary Log…… 846 5.4.5 The Slow Query Log 858 5. 4.6 The DDL Log 860 5.4.7 Server Log Maintenance 860 5.5 MySQL Server Plugins 862 5.5.1 Installing and uninstalling plugins 863 5.5.2 Obtaining Server Plugin Information 867 5.5.3 MySQL Enterprise Thread pool 868 5.5. 4 The Rewriter Query Rewrite Plugin 874 5.55∨ ersion tokens 882 5.6 MySQL Server User-Defined Functions 893 5.6. 1 Installing and Uninstalling User-Defined Functions 894 5.6.2 Obtaining User-Defined Function Information 894 5.7 Running Multiple MysQL Instances on One Machine 895 5.7.1 Setting Up Multiple Data Directories 896 5.7.2 Running Multiple My SQL Instances on Windows 897 5.7.3 Running Multiple MysQL Instances on Unix ∴900 5.7.4 Using Client Programs in a Multiple-Server Environment 901 5.8 Tracing mysqld Using DTrace 902 5.8. 1 mysqld dtrace Probe Reference 903 6 Security… 6. 1 General security Issues 6. 1. 1 Security Guidelines 922 6.1.2 Keeping Passwords Secure 923 6.1.3 Making MySQL Secure Against Attackers ......... 932 6.1.4 Security-Related mysqld Options and Variables 934 6. 1.5 How to Run MySQL as a Normal User 934 MySQL 5.7 Reference Manual 6.1.6 Security Issues with LOAD DATA LOCAL 935 6.1.7 Client Programming Security Guidelines 6.2 The MySQL Access Privilege system 937 6.2. 1 Privileges provided by mysQl 939 6.2.2 Grant tables 6.2.3 Specifying Account Names…….… 950 6.2. 4 Access Control, Stage 1: Connection Verification 952 625 Access Control, Stage2: Request Verification……………955 6.2.6 When Privilege Changes Take Effect 957 6.2.7 Troubleshooting Problems Connecting to MySQL 957 6. 3 My SQL User Account Management 962 6.3. 1 User Names and passwords ∴962 6.3.2 Adding User Accounts 964 6.3. 3 Removing User Accounts .966 6.3.4 Reserved User Accounts .966 6.3.5 Setting account resource Limits ∴966 6.3.6 Assigning Account Passwords 968 6.3.7 Password Management 969 6.3.8 Password Expiration and Sandbox Mode 971 6.3.9 Pluggable Authentication 973 6.3. 10 Proxy Users.. 975 6.3.11 User Account Locking…… 981 6.3. 12 SQL-Based MySQL Account Activity Auditing 982 6.4 Using Encrypted Connections 983 6.4.1 Configuring MysQL to Use Encrypted Connections 985 6.4.2 Command Options for Encrypted Connections 6.4.3 Creating SSL and RSA Certificates and Keys 993 6.4.4 SSL Library-Dependent Capabilities 1002 6.4.5 Building MySQL with Support for Encrypted Connections 1003 6.4.6 Encrypted Connection Protocols and Ciphers 1004 6. 4.7 Connecting to MySQL Remotely from Windows with SSH 1007 6.5 Security Plugins∴.… 1007 6.5.1 Authentication Plugins .1008 6.5.2 The Connection-Control Plugins 1071 6.53 The Password validation Plugin…… 1076 6.5.4 The My SQL Keyring 1083 6.5.5 MySQL Enterprise Audit 1115 6.5.6 My SQL Enterprise Firewall 1177 6.5.7 My SQL Enterprise Data Masking and De-ldentification 1189 7 Backup and Recovery .. 1207 7.1 Backup and Recovery Types 1208 7.2 Database Backup Method 1211 7.3 Example Backup and Recovery Strategy 1213 7.3.1 Establishing a Backup Policy 1213 7.3.2 Using Backups for Recovery 1215 7.3.3 Backup Strategy Summary 1216 7.4 Using mysqldump for Backups 1216 7.4.1 Dumping Data in SQL Format with mysqldump 1216 7.4.2 Reloading SQL-Format Backups 1217 7.4.3 Dumping Data in Delimited-Text Format with mysqldump 1218 7. 4.4 Reloading Delimited-Text Format Backups 1219 7.4.5 mysqldump Tips 1220 7.5 Point-in-Time(Incremental) Recovery Using the Binary Log 1222 7.5.1 Point-in-Time Recovery Using Event Times 1223 7.5.2 Point-in-Time Recovery Using Event Positions 1224 76 Myl SAM Table Maintenance and Crash Recovery……… 1225 7.6. 1 Using myisamchk for Crash Recovery 7.6.2 How to Check Myl SAM Tables for Errors 1226 MySQL 5.7 Reference Manual 7.6.3 How to Repair Myl SAM Tables 1226 7.6. 4 MyISAM Table Optimization 1229 7.6.5 Setting Up a Myl SAM Table Maintenance Schedule 1229 8 Optimization 1231 8. 1 Optimization Overview 1232 8.2 Optimizing sql statements 1234 8.2.1 Optimizing SELECT Statements 1234 8. 2.2 Optimizing Subqueries, Derived Tables, and view References .......... 1276 8.2.3 Optimizing INFORMATION SCHEMA Queries ..s4 1287 8.2. 4 Optimizing Data Change Statements 1292 8.2.5 Optimizing Database Privileges 1293 8.2.6 Other Optimization Tips 1293 8.3 Optimization and Indexes 1294 831 How MySQL Uses Indexes∴… 1294 8.3.2 Primary Key Optimization 1295 8.3. 3 Foreign Key Optimization 1295 8. 3. 4 Column Indexes 1295 8.3.5 Multiple-Column Indexes 1297 8.3.6 Verifying Index Usage…… 1298 8.3.7 Innodb and myisaM Index statistics Collection …………1298 8.3.8 Comparison of B-Tree and Hash Indexes 1300 8.3 9 Use of Index extensio 1301 8.3.10 Optimizer Use of generated column Indexes 1304 8.4 Optimizing Database Structure 1305 8. 4.1 Optimizing Data Size 1305 8.4.2 Optimizing My SQL Data Types 1307 8.4.3 Optimizing for Many tables 1309 8. 4. 4 Internal Temporary table Use in My SQL 1310 8.5 Optimizing for InnoDB Tables.... 1312 8.5. 1 Optimizing Storage Layout for InnoDB Tables 1312 8.5.2 Optimizing Innodb transaction management 1313 8.5.3 Optimizing InnoDB Read-Only Transactions ∴1314 8.5. 4 Optimizing InnodB Redo logging 1315 8.5.5 Bulk Data Loading for InnoDB Tables 1316 8.5.6 Optimizing InnoDB Queries 1317 8.5.7 Optimizing InnoDB DDL Operations 1317 8.5.8 Optimizing InnoDB Disk 1/O 1318 8.5.9 Optimizing InnoDB Configuration variables 1320 8.5.10 Optimizing InnoDB for Systems with Many Tables 1322 8.6 Optimizing for MyISAM Tables 1322 8.6. 1 Optimizing MylSAM Queries 1322 8.6.2 Bulk Data Loading for MyISAM Tables 1323 8.6. 3 Optimizing repair table statements 1325 8.7 Optimizing for MEMORY Tables 8.8 Understanding the Query Execution Plan 1326 1326 8.8.1 Optimizing Queries with EXPLAIN 1326 8.8.2 EXPLAIN Output Format .1327 8.8.3 Extended EXPLAIN Output Format .1340 8.8.4 Obtaining Execution Plan Information for a Named Connection 1342 8.8.5 Estimating Query Performance 1343 8.9 Controlling the Query Optimizer 1343 8.9.1 Controlling Query Plan Evaluation…… 1343 8.9.2 ptimizer Hints….…, 1344 8.9.3 Switchable Optimizations.... 1350 89.4 Index Hints 1354 8.9.5 The Optimizer cost Model 1356 8.10 Buffering and Caching 1360 8. 10. 1 InnoDB Buffer Pool Optimization 1360 MySQL 5.7 Reference Manual 8.10.2 The MyIsAM Key Cache 1360 8.10.3 The MySQL Query Cache 1364 8. 10.4 Caching of Prepared Statements and Stored Programs 1371 8.11 Optimizing Locking Operations .1373 8.11.1 Internal Locking Methods 1373 8.11.2 Table Locking Issues 1375 8.11. 3 Concurrent Inserts 1377 8. 11.4 Metadata Locking 1377 8.11.5 External Locking 1380 8. 12 Optimizing the My sQL Server 1381 8. 12.1 System Factors 1382 8.12.2 Optimizing disk∥O……, 1382 8.12.3 Using symbolic Links 1383 8. 12. 4 Optimizing Memory Use 1386 8. 12.5 Optimizing Network 1392 8. 13 Measuring Performance( Benchmarking .1395 8.13.1 Measuring the speed of EXpressions and Functions 1396 8.13.2 Using your Own Benchmarks 1396 8.13.3 Measuring Performance with performance schema 1397 8. 14 Examining Thread Information 1397 8. 14.1 Thread command values 1398 8. 142 General thread states 1400 8.14.3 Query Cache Thread states 1406 8. 14.4 Replication Master Thread States 1406 8. 14.5 Replication Slave l/o Thread states 1407 8. 14.6 Replication Slave sQl Thread states 1408 8. 14.7 Replication Slave Connection Thread States 1409 8. 14.8 NDB Cluster Thread states 1409 8. 14.9 Event scheduler thread states 1410 9 Language structure 1411 9.1 Literal values 1411 9.1.1 String Literals 1411 9.1.2 Numeric Literals 1414 9.1. 3 Date and Time literals 1414 9.1.4 Hexadecimal Literals 1416 9.1.5Bit∨ alue literals∴ 1418 9.1. 6 Boolean literals ..1420 9.1.7 NULL Values 1420 9. 2 Schema Object Names 1420 9.2.1 Identifier qualifiers 1422 9.2.2 Identifier Case Sensitivity 1424 9.2. 3 Mapping of Identifiers to File Names..............................1426 9.2. 4 Function Name Parsing and resolution 1429 9. 3 Keywords and reserved Words 1432 9.4 User-Defined variables 1454 9.5 Expressions 1458 9. 6 Comment Syntax 1462 10 Character Sets, Collations. Unicode 画 1465 10.1 Character sets and collations in general 1466 10.2 Character sets and collations in MySQL 1467 10.2.1 Character set Repertoire 1468 10.22 UTF-8 for metadata 1470 10.3 Specifying Character Sets and Collations 1471 10.3.1 Collation Naming Conventions 1472 10.3.2 Server Character Set and Collation 1473 10.3. 3 Database character set and collation 1473 10.3.4 Table Character set and collation 1474 10.3.5 Column Character set and collation 1475 IX MySQL 5.7 Reference Manual 10.3.6 Character String Literal character Set and Collation 1476 10.3.7 The National character set ∴1478 10.3.8 Character set Introducers 1479 10.3.9 Examples of Character Set and Collation Assignment 1480 10.3. 10 Compatibility with other DBMss 1481 10.4 Connection character sets and collations IIb1 I 1481 10.5 Configuring Application Character Set and Collation 1488 10.6 Error Message Character set 1489 10.7 Column Character Set Conversion 1490 10.8 Collation issues 1492 10.8.1 Using COLLATE in SQL Statements 1492 10.8.2 COLLATE Clause Precedence .1492 10.8.3 Character Set and collation Compatibility 1493 0. 8. 4 Collation Coercibility in Expressions 1493 10.8.5 The binary Collation Compared to bin Collations ..... 1494 10.8.6 Examples of the Effect of Collation 1496 10.8.7 Using Collation in INFORMATION SCHEMA Searches 1497 10.9 Unicode Support 1499 10.9. 1 The utf8mb4 Character Set(4-Byte UTF-8 Unicode Encoding)......... 1501 10.9.2 The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding) .1501 10.9.3 The utf8 Character Set (Alias for utf8mb3) 1502 10.94 The ucs2 Character set(Ucs2 Unicode Encoding)…………………1502 10.9.5 The utf16 Character Set (UTF-16 Unicode Encoding) 1502 0.9.6 The utf16le Character Set(UTF-16LE Unicode Encoding) 1503 10. 9. 7 The utf32 Character Set (UTF-32 Unicode Encoding 1503 10.9.8 Converting Between 3-Byte and 4-Byte Unicode Character Sets 1504 10.10 Supported Character Sets and Collations 1506 10.10.1 Unicode character sets 1507 10.10.2 West European character sets 1512 10.10.3 Central European Character Sets 1513 10. 10.4 South european and middle east character Sets 1514 10.10.5 Baltic Character sets 1515 10.10.6 Cyrillic Character Sets 1515 10.10.7 Asian character sets 1515 10.10.8 The Binary Character Set 1520 10.11 Setting the Error Message Language..,…,…… 1520 10. 12 Adding a Character Set 1521 10.12.1 Character Definition Arrays 1523 10. 12.2 String Collating Support for Complex Character Sets 1524 10. 12.3 Multi-Byte Character Support for Complex Character Sets 1524 10.13 Adding a Collation to a Character Set 1524 10. 13.1 Collation Implementation Types .1525 10. 13.2 Choosing a Collation ID 1528 0. 13.3 Adding a Simple Collation to an 8-Bit Character Set 1529 10.13. 4 Adding a UCA Collation to a Unicode Character Set 1530 10.14 Character Set configuration 1537 10.15 MySQL Server Locale Support 1538 11 Data Types ii0idddi 1541 11.1 Data Type Overview 1542 11.1.1 Numeric Type Overview .1542 11.1.2 Date and Time Type Overview .1545 1.1.3 String Type Overview 11.2 Numeric Types∴.….….…. 1550 11.2. 1 Integer Types(Exact Value)-INTEGER, INT, SMALLINT, TINYINT MEDIUMINT BIGINT 1551 11.2.2 Fixed-Point Types(Exact Value)-DECIMAL, NUMERIC 1551 11.2.3 Floating-Point Types(Approximate Value)-FLOAT, DOUBLE 1552 11.2.4 Bit-Value Type-BIT 1552

(系统自动生成,下载前可以参看下载内容)