Mysql Chinese Reference Manual
Translator: 子 (clyan@sohu.com) ???? Home: http://linuxdb.yeah.net
0? Translator's order 1 mysql general information
1.1 What is mysql? 1.2 About this manual
1.2.1 The agreed 1.3 Mysql's history 1.4 mysql stability is 1.5 mysql stability? 1.6 Adaptation 2000 1.7 SQL General Information and Tutorial 1.8 Useful mysql related link 2 mysql mailing list and how to ask or report errors
2.1 MYSQL Mail List 2.2 Questions or Report Errors 2.3 How to report errors or problems 2.4 Guide to answer questions on your mailing list 3 MySQL license and technical support
3.1 mysql license policy 3.2 mysql? Use copyright
3.2.1 Possible future copyright changes 3.3 MySQL Commercial Distribution 3.4 License
3.4.1 Sales Use? MySQL Products 3.4.2 Sales MySQL Related Services 3.4.3 ISP ?? MySQL Services 3.4.4 Operate a web server using mysql ?? 3.5 mysql license and technical support fees
3.5.1 Payment Information 3.5.2 Contact Information 3.6 The type of commercial support
3.6.1 Basic Email Support 3.6.2 Extended Email Support 3.6.3 Login Support 3.6.4 Extended Login Support 4 Installation? MySQL?
4.1 How to get mysql? 4.2 mysql supported operating system 4.3 Which version of the use of mysql 4.4 How to release update version 4.5 Installation layout 4.6 Install MYSQL binary code distribution
4.6.1 Linux? RPM Precautions 4.6.2 Constructing a Customer Division 4.6.3 System Specific Problems
4.6.3.1 Linux Precautions 4.6.3.2 HP-UX? Precautions 4.7 Installation? MySQL Source Code Distribution
4.7.1 Quick Installation Overview 4.7.2 Working with Typical Configure Options 4.8 Compiling Questions? 4.9 mit-pthreads? Precautions 4.10 Perl installation instructions
4.10.1 Installing on the UNIX operating system? Perl 4.10.2 installed on the Win32? ActiveState ?? Perl 4.10.3 is installed on? Win32? Mysql ?? Perl? Distribute 4.10.4? Perl? DBI / DBD Problems encountered in interface 4.11 System specific issues
4.11.1 Solaris Precautions 4.11.2 Solaris? 2.7? Precautions 4.11.3 Solaris ?? x86? Precautions 4.11.4 SunOS? 4? Precautions 4.11.5 Linux? (All Linux Version) Notes
4.11.5.1 Linux-x86? Precautions 4.11.5.2 Redhat ?? 5.0? Precautions 4.11.5.3 Redhat ?? 5.1? Precautions 4.11.5.4 Linux-SPARC? Precautions 4.11.5.5 Linux-Alpha? Notes 4.11.5.6 MKLINUX? Precautions 4.11.5.7 QUBE2 ?? Linux? Precautions 4.11.6 Alpha-Dec-UNIX? Precautions 4.11.7 Alpha-Dec-OSF1? Precautions 4.11.8 SGI-IRIX? Precautions 4.11.9 FreeBSD? Precautions 4.11.10 NetBSD? Precautions 4.11.11 BSD / OS? Precautions
4.11.11.1 BSD / OS ?? 2.x? Notes 4.11.11.2 BSD / OS ?? 3.x? Notes 4.11.11.3 BSD / OS ?? 4.x? Precautions 4.11.12 SCO? Precautions 4.11 .13 SCO ?? Unixware? 7.0? Notes 4.11.14 IBM-AIX? Precautions 4.11.15 HP-UX? Precautions 4.12 Win32? Precautions
4.12.1 is installed on? Win32? Mysql? 4.12.2 started on? Win95? / Win98? MySQL 4.12.3 is started on? Mysql? 4.12.4 Run mysql? 4.12 on? Win32? 5 Use? Ssh? From? Win32? Connect a remote mysql 4.12.6 mysql-win32 and UNIX? MySQL? Comparison? 4.13 OS / 2? Precautions 4.14 TCX? Binary code 4.15 installation post-installation settings and testing 4.15.1 Running mysql_install_db problem 4.15.2 Start? Mysql? Server problem 4.15.3 Automatic start and stop? MySQL? 4.15.4 Options file 4.16 What is the thing you have to do when you upgrade and downgrading?
4.16.1 Upgrade from one? 3.22? 2.23? 4.16.2 From one? 3.21? Version upgrade? 3.22? 4.16.3 From one? 3.20? Version upgrade to? 3.21? 4.16.4 Upgrade to other systems Structure 5 mysql? Compatibility with standards?
5.1 Mysql Exchange 5.2 Run in ANSI mode? MySQL? 5.3 mysql 5.4 mysql? Lack of functionality than ANSI? SQL92
5.4.1 Sub-selects 5.4.2 Select INTO TABLE 5.4.3 Transactions 5.4.4 Storage Procedure and Trigger 5.4.5 Foreign Keys
5.4.5.1 Reasons for Experts 5.4.6 View (Views) 5.4.7 '-' As an annotation 5.5 mysql? What standards are followed? 5.6 How to deal with no submission / rollback (COMMIT / ROLLBACK 6 mysql? Access permission system
6.1 Permission System What 6.2 mysql User Name and Password 6.3 With MySQL Server Connection 6.4 Make your password security 6.5 mysql? Provide permissions 6.6 Permissions System Working principle 6.7 Access control, stage 1: Connection confirm 6.8 Access control, stage 2: Request confirmation 6.9 Permissions Change When to take effect 6.10 Creating initial? MySQL Permissions 6.11 Increase New User Permissions to MySQL 6.12 How to Set the Password 6.13 Access Denger Reason 6.14 How to make mysql security to confirm the Miki Master (CRACKER) 7 MySQL? Language reference
7.1 Text: How to write strings and numbers
7.1.1 String 7.1.2 Number 7.1.3 Hexadecimal 7.1.4 NULL Value 7.1.5 Database, Table, Index, Column, and Alias Name
7.1.5.1 Size-sensitive Sensitivity 7.2 User Variables 7.3 Column Type
7.3.1 Column Type Storage Requirements 7.3.5 Digital Type 7.3.6 Date and Time Type
7.3.6.1 Problems and Date Types 7.3.6.2 DateTime, Date and TimeStamp Type 7.3.6.3 Time Type 7.3.6.4 Year Type 7.3.7 String Type
7.3.7.1 CHAR and VARCHAR Type 7.3.7.2 BLOB and TEXT Type 7.3.7.3 ENUM Type 7.3.7.4 SET Type 7.3.8 For columns Select the correct type 7.3.9 Column index 7.3.10 multi-column index 7.3.11 Use from other Column Type of the Database Engine 7.4 Use the function of SELECT and WHERE clauses
7.4.1 Grouping functions 7.4.2 Common Arithmetic Operation 7.4.3 Bit Functions 7.4.4 Logic Operation 7.4.5 Comparison Operator 7.4.6 String Compare Functions 7.4.7 Type Conversion Operator 7.4.8 Control Stream Function 7.4. 9 Mathematical Functions 7.4.10 String Functions 7.4.11 Date and Time Functions 7.4.12 Other Functions 7.4.13 Works with Group By clauses 7.5 Create Database (Create Database) Sentence 7.6 DROP DATABASE 7.7 CREATE TABLE SETRIAL 7.7 Included (Silent) Specify Change 7.8 Alter Table 7.9 Optimize Table (Optimization Table) Sentiment 7.11 DROP TABLE (Abandoned) Sentence 7.11 Delete 7.12 Select (selection) syntax 7.14 INSERT (insert) syntax 7.15 Replace (replace) Sentence 7.16 Load data infile 7.17 Update (Update) Sentence 7.18 USE (Used) Sentence 7.19 Flush ( Clear Cache) Sentence 7.20 Kill (Kill) Sentence 7.21 show (Show) Syntax (Information About Table, Column) 7.22 Explain Syntax (About SELECT) 7.23 Describe (Description) Syntactic (Get column) Information) 7.24 Lock Tables / UNLOCK TABLES (Lock Table / Unlocking Table) Sentiment 7.25 Set Option (Settings Options) Sentiment 7.26 Grant (Authorization) and Revoke (Withdrawal) Sentence 7.27 Create Index 7.28 DROP INDEX (Abandon Index) Syntactic 7.29 NETRCHD 7.30 CREATE FUNCTION / DROP FUNCTION 7.31 MySQL is very picky to the reserved word? 8 mysql? Tutorial
8.1 Joints and Disconnect Servers 8.2 Enter the query 8.3 Examples of common queries
8.3.1 The maximum value of 8.3.2 Rows of rows 8.3.3 column with a column: Press group: Only 8.3.4 Row 8.3.5 using the largest value of the group with a field Outer key 8.4 Create and use a database
8.4.1 Creating and selecting a database 8.4.2 Creating a database table 8.4.3 Loading the data into database table 8.4.4 Retrieve information from a database table
8.4.4.1 Select all data 8.4.4.2 Select a specific row 8.4.4.3 Select Specific columns 8.4.4.4 Sort 8.4.4.5 Date Calculation 8.4.4.4 NULL Value Operation 8.4.4.8 Matches 8.4.4.8 Range Count 8.4.5 Use multiple Database Table 8.5 Getting Database and Table Information 8.6 Using Mysql 8.7 in Batch Processing Search from "Two"
8.7.1 Find out all non-alone twins 8.7.2 Display Table 9 Mysql? Server function about twins
9.1 MYSQL? What languages do you support?
9.1.1 Character Sets for Data and Sort 9.1.2 Add a new character set 9.1.3 Multi-byte character support 9.2 Update Log 9.3 MYSQL Database Table How big? 9.4 MYSQL Database Table Type 10 From? MySQL? Get maximum performance
10.1 Optimization Overview 10.2 Regulation of System / Compile Time and Startup Parameters
10.2.1 How does compilation and link affect? MySQL? Speed 10.2.2 disk problem
10.2.2.1 Use symbolic links for databases and tables 10.2.3 Adjust server parameters 10.2.4 mysql? How to open and close Database Table 10.2.5 Creating a large number of database tables in the same database 10.2.6 Why is there so much open? table? 10.2.7 mysql? How to use memory 10.2.8 mysql? How to lock database table 10.2.9 Database table lockup problem 10.3 Make your data as small as possible 10.4 mysql? Index 10.5 Access or Update Data's query speed 10.5 .1 Estimation Query Performance 10.5.2 SELECT query speed 10.5.3 mysql? How to optimize WHERE clause 10.5.5 mysql? How to optimize Left Join 10.5.5 mysql? How to optimize limit 10.5.6 insert query speed 10.5.7 Update Query speed 10.5.8 Delete query speed 10.6 Select a table type
10.6.1 Characteristics of Static (Pixel) Table 10.6.2 Dynamic Table Features 10.6 Compression Table Features 10.4 In-Memory Table Table Features 10.7 Other Optimization Tips 10.8 Use your own benchmark 10.9 Design Selection 10.10 mysql? Design Limit / Comprehensive 10.11 Portability 10.12 Where have you been using mysql? 11 mysql? Benchmark Kit 12 MySQL? Utility
12.1 Various? MySQL? Program Overview 12.2 Managing one? Mysql? Server 12.3 From? MySQL? Database and Data 12.4 Import data from text file 12.5 mysql? Compression Ready table generator 13 Maintenance? Mysql? Installation
13.1 Table maintenance and crash recovery using Myisamchk
13.1.1 Myisamchk call syntax 13.1.2 Myisamchk's memory use 13.2 13.2? Creating a database table maintenance specification 13.3 Getting information about a table 13.4 Crash recovery using MyisamCHK
13.4.1 How to check the error 13.4.2 How to fix table 13.4.3 Table Optimization 13.5 Log File Maintenance 14 Add new functions for MySQL
14.1 Add a new user-defined function
14.1.1 UDF Call Order? 14.1.2 Parameter Processing 14.1.3 Return Value and Error Process 14.1.4 Compiling and Install User-Defined Functions 14.2 Add a new native (Native) function 15 Add new process for MySQL
15.1 Analysis Process 15.2 Writing a process 16 mysql pair? ODBC? Support
16.1 MYODBC? Supported operating system 16.2 How to report? Myodbc problem 16.3 Know how to use the "Myodbc work" How to fill in? ODBC? Managers 16.5 How to get an auto_increment column in ODBC 16.6 Report? Myodbc? Problem 17 uses mysql with some common procedures
17.1 Use with? Apache? MySQL? 18 issues and common errors
18.1 What if MySQL always crashes 18.2 Use? MySQL? Some common errors
18.2.1 Mysql Server Has Gone Away Error 18.2.2 CAN't Connect To [local] mysql server error 18.2.3 Host '...' is blocked error 18.2.4 Out of memory error 18.2.5 Packet TOO LARGE Error 18.2 .6 Table Is Full Error 18.2.7 Commands Out of Sync in Client Error 18.2.8 Ignoring User Error 18.2.9 Table 'XXX' Doesn't EXIST Error 18.3 Mysql? How to deal with an overflow disk 18.4 How to get from a text file Run SQL command 18.5 mysql? Where to store temporary file 18.6 How to protect "/TMP/Mysql.sock" Not deleted 18.7 Access Denied error 18.8 How to run as a general user? MySQL 18.9 How to reset a forgotten password 18.10 file license Question 18.11 Did not find 18.12 Using Date Columns 18.13 Time Zone Problem 18.14 Sample Sensitive 18.15 NULL Value Problem 18.16 Alias Problems 18.17 Deleting Row from related tables 18.18 Resolving problems with no match 18.19 ALTER TABLE INT How to change the order in a table 19 Solve MySQL? Some common problems 19.1 Database Copy 19.2 Database Backup 19.3 Run multiple? MySQL? Server 20 MySQL? Customer Tools and? API
20.1 mysql ?? c? API 20.2 C? API Data Type 20.3 C? API Function Overview 20.4 C? API Function Description
20.4.1 mysql_affected_rows? () 20.4.2 mysql_close? () 20.4.3 mysql_connect? () 20.4.4 mysql_change_user? () 20.4.5 mysql_create_db? () 20.4.6 mysql_data_seek? () 20.4.7 mysql_debug? () 20.4 .8 mysql_drop_db? () 20.4.9 mysql_dump_debug_info? () 20.4.10 mysql_eof? () 20.4.11 mysql_errno? () 20.4.12 mysql_error? () 20.4.13 mysql_escape_string? () 20.4.14 mysql_fetch_field? (20.4). 15 mysql_fetch_fields? () 20.4.16 mysql_fetch_field_direct? () 20.4.17 mysql_fetch_lengths? () 20.4.18 mysql_fetch_row? () 20.4.19 mysql_field_count? () 20.4.20 mysql_field_seek? () 20.4.21 mysql_field_tell? (20.4.22) mysql_free_result? () 20.4.23 mysql_get_client_info? () 20.4.24 mysql_get_host_info? () 20.4.25 mysql_get_proto_info? () 20.4.26 mysql_get_server_info? () 20.4.27 mysql_info? () 20.4.28 mysql_init? () 20.4.29 mysql_insert_id ? () 20.4.30 mysql_kill? () 20.4.31 mysql_list_dbs? () 20.4.32 mysql_list_fields? () 20.4.33 mysql_list_processes? () 20.4.34 mysql_list_tables? () 20.4.35 mysql_num_fields? () 20.4.36 mysql_num_rows? () 20.4.37 m ysql_options? () 20.4.38 mysql_ping? () 20.4.39 mysql_query? () 20.4.40 mysql_real_connect? () 20.4.41 mysql_real_query? () 20.4.42 mysql_reload? () 20.4.43 mysql_row_seek? () 20.4.44 mysql_row_tell ? () 20.4.45 mysql_select_db? () 20.4.46 mysql_shutdown? () 20.4.47 mysql_stat? () 20.4.48 mysql_store_Result? () 20.4.49 mysql_thread_id? () 20.4.50 mysql_use_result? ()
20.4.51 Why is Mysql_Store_Result () after mysql_query (), mysql_store_result () sometimes returns NULL? 20.4.52 What results I get from the query? 20.4.53 How can I get the only ID of the last inserted row? 20.4.54 Link? C? API problem 20.4.55 How to make a thread-saffe's customer 20.5 mysql ?? Perl? API20.5.1 DBI and DBD :: mysql 20.5.2 DBI interface 20.5.3 More DBI / DBD information 20.6 mysql Eiffel packaging 20.7 mysql Java connection (JDBC) 20.8 mysql ?? php? API 20.9 mysql? C ? API? 20.10 MySQL Python API 20.11 MySQL TCL API 21 How to compare Mysql and other databases
21.1 How to compare Mysql and MSQL?
21.1.1 How to convert MSQL tools to mysql 21.1.2 msql and mysql? The client / server communication protocol is different from 21.1.3? Msql? 2.0 SQL sentence method and mysql What is different 21.2 How to compare Mysql and PostgreSQL? A Some ? Mysql? User B contributes the program c mysql contributor D mysql? The history of the change in E mysql is wrong and design List F We want to join the mysql? Schedule (? Todo?) G Migrating to other systems h mysql? Regular expression syntax description i? Unireg? J For non-Microsoft operating systems? MySQL? Server license k for Microsoft operating systems? Mysql? License SQL Command, Type, and Function Index Concept Index
