MySQL Chinese Reference Manual (Catalog) Reprinted
Translator: 子
〖
Back to〗 Forward〗
Translator: 子 (clyan@sohu.com) Home: http://linuxdb.yeah.net0 Translator's order 1 mysql general information 1.1 What is mysql? 1.2 About this manual 1.2.1 The agreement of 1.3 mysql in this manual 1.5 mysql stability? 1.6 Adaptation 2000 1.7 SQL General Information and Tutorial 1.8 Useful MySQL Related Links 2 MySQL Mail List and How to Questions or Report Errors 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 used copyright 3.2.1 Possible future copyright change 3.3 MySQL Commercial Distribution 3.4 License Firm 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 WeSQL Web Server 3.5 MySQL license and technical support costs 3.5.1 Payment information 3.5.2 Contact information 3.6 Commercial support type 3.6.1 Basic email Support for 3.6.2 Extended email support 3.6.3 Login Support 3.6.4 Extended Login Support 4 Installing Mysql 4.1 How to get Mysql 4.2 MySQL Support Operating System 4.3 Which version 4.4 How to Publish Update version 4.5 Installation layout 4.6 Install MySQL Binary Code Distribution 4.6.1 Linux RPM Notes 4.6.2 Construct Customer Division 4.6.3 System Specific Issues 4.6.3.1 Linux Precautions 4.6.3.2 HP-UX Precautions 4.7 Install MySQL Source Code Distribution 4.7.1 Fast code distribution 4.7.1 Installation Overview 4.7.2 Using Patch 4.7.3 Typical Configure Options 4.8 Compiling Questions?
4.9 MIT-PTHREADS Precautions 4.10 Perl Installation Description 4.10.1 Installing Perl 4.10.2 on UNIX Operating System Installing ActiveState Perl 4.10.3 Installing MySQL Perl on Win32 Distribution 4.10.4 Using Perl DBI / DBD Interface Question 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 Versions) Notes 4.11.5.1 linux -x86 Precautions 4.11.5.3 Redhat 5.1 Precautions 4.11.5.4 Linux-SPARC Precautions 4.11.5.5 Linux-Alpha Precautions 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 Notes 4.11.9 FreeBSD Notes 4.11.11 BSD / OS Notes 4.11.11.1 BSD / OS 2.X Notes 4.11.11.2 BSD / OS 3.X Precautions 4.11.11.3 BSD / OS 4.x Precautions 4.11.12 SCO Notes 4.11.13 Sco Unixware 7.0 Precautions 4.11.14 IBM-AIX Precautions 4.11.15 HP-UX Precautions 4.12 Win32 Precautions 4.12.1 Install MySQL 4.12.2 on Win32 Start Mysql 4.12.3 on NT on Win32 Run Mysql 4.12.5 on Win32 SSH is connected from Win32 to a remote mysql 4.12.6 mysql-win32 and UNIX mysql comparison 4.13 OS / 2 Notes 4.14 TCX Binary Code 4.15 Installation (P OST-Installation Settings and Test 4.15.1 Running MySQL_INSTALL_DB Problems 4.15.2 Launching the Mysql Server Issues 4.15.3 Automatic Starting and Stop MySQL 4.15.4 Options File 4.16 Upgrade and Downgrading DowngRading What is important? Do you? 4.16.1 Upgrade from a 3.22 version to 3.23 4.16.2 Upgrade from a 3.21 version to 3.21 4.16.4 Upgrade to 3.21 4.16.4 Upgrade to other architecture 5 MySQL and standard compatibility? 5.1 mysql Exchange 5.2 Run mysql 5.3 mysql in ANSI SQL92 5.4 Mysql Lack of Different Functions 5.4.1 Sub-selects 5.4.2 Select Into Table 5.4.3 Transactions (Transactions) 5.4 .4 Storage Procedure and Trigger 5.4.5 Foreign Keys 5.4.5.1 Reasons for Transport 5.4.6 View (Views) 5.4.7 '-' What standards are followed as a note 5.5 mysql?
5.6 How to deal with no submission / rollback 6 MySQL Access Permission System 6.1 Permissions System What 6.2 Mysql User Name and Password 6.3 With MySQL Server Connection 6.4 Make your password security 6.5 mysql provides permission 6.6 Permissions System Working principle 6.7 Access Control, Phase 1: Connection confirmation 6.8 Access control, stage 2: Request confirmation 6.9 Permissions Change When to take effect 6.10 Establish initial mysql permission 6.11 Adding new user rights to MySQL 6.12 How to set the password 6.13 Access denied (Access Denied) Cause 6.14 How to make mysql secure to confront the MYS 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 value 7.1.4 NULL Name 7.1.5 Database, Table, Index, Column, and Alias Name 7.1.5.1 Size 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.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 Using column types from other database engines 7.4 use in SELECT and WHERE clauses 7.4.1 Group function 7.4.2 Common arithmetic operation 7.4.3 Bit function 7.4.4 Logic Operation 7.4.5 Comparison Operator 7.4.6 String Compare Function 7.4.7 Type Conversion Operator 7.4.8 Control Stream Function 7.4.9 Mathematics Function 7.4.10 String Function 7.4.11 Date and Time Functions 7.4.12 Other Functions 7.4.13 Works with Group By clauses 7.5 Create Database SyX 7.6 DROP DATABASE (Abandoned Database) Sentence 7.7 Create Table Creating a table) Sentence 7.7.1 InjiTed column specified change 7.8 Alter TA BLE (Change Table) Sentet 7.9 Optimize Table (Optimization Table) Sentiment 7.11 Delete (Delete) Sentence 7.12 Synth Syntax 7.13 Join (Joint) Sentence 7.14 INSERT (Insert) Sentence 7.15 Replace Replacement) Sentence 7.16 Load Data Infile (loading data to file) syntax 7.17 Update 7.19 USE (use) syntax 7.19 Flush (Clear Cache) Sentence 7.20 Kill (Kill) Sentence 7.21 Show (Show) Syntax , Listed information) 7.22 Explain Syntax (information about SELECT) 7.23 Describe (Description) Syntax (Description) Syntax (Description) 7.24 Lock Tables / Unlock Tables (Lock Table / Unlock Table) Sentence 7.25 Set Option Options) Sentence 7.26 Grant (Authorized) and Revoke (Withdrawal) Sentimentation 7.27 Create Index Syntax 7.28 DROP INDEX (Abandoned Index) Sentence 7.29 Note Syntactic 7.30 Create Function / DROP FUNCTION (Create Function / Abandon) Sentence 1.31 MySQL Do you be very picky?
8 mysql tutorial 8.1 Joint and disconnect server 8.2 Enter the query 8.3 Example of common queries 8.3.1 Maximum value 8.3.2 Have a row of rows 8.3.3 column of a column 8.3.3: Press group: Only 8.3 .4 Row 8.3.5 with a larger value of a field 8.3.5 Create and use a database 8.4.1 to create and select a database 8.4.2 Creating a database table 8.4.3 Put the data into database table 8.4 .4 From a database table search information 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 Rank 8.4.4.5 Date Calculation 8.4.4.4 Matches 8.4.4.8 Row count 8.4.5 Using multiple database tables 8.5 Getting Database and Table Information 8.6 Using Mysql 8.7 in Batch Projects 8.7.1 Finding All Diet Twins 8.7.2 Displaying About Delivery Table 9 MYSQL server function 9.1 MYSQL supports which languages? 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 System / Compile Time and Start Parameters 10.2.1 How to Compile and Link How to affect the speed of MySQL 10.2.2 Disk problem 10.2.2.1 is a database and table use symbol Link 10.2.3 Adjusting Server Parameters 10.2.4 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 many open tables? 10.2.7 Mysql How to Use Memory 10.2.8 Mysql How to Lock Database Table 10.2.9 Database Table Level Locked Problem 10.3 Make your data as little 10.4 mysql index 10.5 access or update data 10.5.1 estimate Query performance 10.5.2 SELECT query speed 10.5.3 how to optimize WHERE clause 10.5.4 mysql How to optimize Left Join 10.5.5 mysql How to optimize the speed 10.5.6 insert query 10.5.7 Update query speed 10.5.8 Delete query speed 10.6 Select a table type 10.6.1 Static (fixed length) table Features 10.6 Dynamic table Features 10.6 Compression Table Features 10.6 Memory (in-Memory Table) Features 10.7 Other Optimization Tips 10.8 Using your own benchmark 10.9 Design Selection 10.10 mysql design limit / compromise 10.11 Portability 10.12 How do we use mysql?
11 Mysql Bench Kit 12 MySQL Utility 12.1 Various mysql Program Overview 12.2 Managing a MySQL Server 12.3 Pouring from the MySQL Database and Table 12.4 From Text File Import Data 12.5 MySQL Compression Read Reading Table Generator 13 Maintenance MySQL installation 13.1 Table Maintenance and Crash Use Myisamchk Recovery 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 Using MyisamCHK to recover how to recover 13.4.1 Checklist 11.4.2 How to fix table 13.4.3 Table Optimization 13.5 Log File Maintenance 14 Add a new user-defined function 14.1 Add a new user-defined function 14.1.1 UDF call sequence 14.1.2 Parameter processing 14.1.3 Return value and Error Treatment 14.1.4 Compile and Install User-Defined Functions 14.2 Add a new native function 15 Add a new process for MySQL 15.1 Analysis Procedure 15.2 Writing a process 16 mysql to ODBC 16.1 Myodbc supported operating system 16.2 How to report Myodbc Question 16.3 Programs known to work with MyodBC 16.4 How to fill in the various domains of the ODBC manager 16.5 How to get an Auto_Increment column in ODBC 16.6 Report MyodBC issues with some common programs Working with Apache MySQL 18 Issues and Common Errors 18.1 What if MySQL always crashes 18.2 Some common errors when using MySQL 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 1 8.2.9 Table 'XXX' Doesn't EXIST Error 18.3 Mysql How to Handle A Spilled Disk 18.4 How to Run from a text file SQL command 18.5 MySQL Where to store temporary file 18.6 How to protect "/TMP/Mysql.sock" is not removed 18.7 ACCESS DENIED Error 18.8 How to run mysql 18.9 How to reset a forgotten password 18.10 File License Permissions Problem 18.11 File No 18.12 Using Date Columns 18.13 Time Zone Problem 18.14 Samples Sample Samples in Search 18.15 NULL Values Question 18.16 ALIAS Problem 18.17 Deleting rows from related tables 18.18 Solving problems with no matching line 18.19 ALTER TABLE INFORMENT 18.20 How to change the order of the columns in a table 19 Resolving some common problems in a table 19.1 Database Copy 19.2 Database Backup 19.3 in the same machine Run multiple mysql servers 20 mysql client tools and API20.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 mysql_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_reeload () 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 MySQL_Query () Returns Mysql_Store_Result () sometimes returns NULL? 20.4.52 What is the result I can get from the query? 20.4.53 How can I get the only ID of the last inserted row?