MySQL Chinese reference manual (catalog)

mysql| Reference | reference Manual | chinese
MySQL Chinese reference manual (catalog)
Reprinted translator: Yan Zi

return 〗〖 Forwarding


Translator: Yan Zi (clyan@sohu.com) Homepage: http://linuxdb.yeah.net

0 Translator Preface
1 General information of the MySQL
1.1 What is MySQL?
1.2 About this manual
1.2.1 The conventions used in this manual
The history of 1.3 MySQL
Main features of 1.4 MySQL
1.5 mysql stability?
1.6 Conform to 2000
1.7 SQL General Information and tutorials
1.8 Useful MySQL RELATED links
2 MySQL Mailing list and how to ask questions or report errors
2.1 MySQL Mailing list
2.2 Questioning or reporting errors
2.3 How to report errors or problems
2.4 Guide to answering questions on the mailing list
3 License and technical support for MySQL
3.1 MySQL license policy
3.2 MySQL use of copyright
3.2.1 Possible future Copyright changes
3.3 MySQL Commercial distribution
3.4 License Instances
3.4.1 Sales of products using MySQL
3.4.2 Sales MySQL-related services
3.4.3 ISP MySQL Service
3.4.4 runs a Web server that uses MySQL
3.5 MySQL License and technical support fees
3.5.1 Payment Information
3.5.2 Contact information
3.6 Types 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 Installing MySQL
4.1 How to get MySQL
4.2 MySQL-supported operating system
4.3 use mysql which version
4.4 How and when to release the updated version
4.5 Installation Layout
4.6 Installing MySQL binary code distribution
4.6.1 Linux RPM Considerations
4.6.2 constructs the client program
4.6.3 System-specific issues
4.6.3.1 Linux Considerations
4.6.3.2 HP-UX Considerations
4.7 Installing MySQL source code distribution
4.7.1 Quick Installation Overview
4.7.2 Using Patches
4.7.3 Typical Configure Options
4.8 compilation issues?
4.9 Mit-pthreads Matters needing attention
4.10 Perl Installation Instructions
4.10.1 to install Perl on UNIX operating systems
4.10.2 to install ActiveState Perl on Win32
4.10.3 Install MySQL Perl distribution on Win32
4.10.4 problems with the Perl DBI/DBD interface
4.11 System-specific issues
4.11.1 Solaris Considerations
4.11.2 Solaris 2.7 Considerations
4.11.3 Solaris x86 considerations
4.11.4 SunOS 4 points to note
4.11.5 Linux (all Linux versions) considerations
4.11.5.1 Linux-x86 Matters needing attention
4.11.5.2 RedHat 5.0 points to note
4.11.5.3 RedHat 5.1 points to note
4.11.5.4 Linux-sparc Matters needing attention
4.11.5.5 Linux-alpha Matters needing attention
4.11.5.6 MkLinux Matters needing attention
4.11.5.7 Qube2 Linux Considerations
4.11.6 Alpha-dec-unix Matters needing attention
4.11.7 ALPHA-DEC-OSF1 Matters needing attention
4.11.8 Sgi-irix Matters needing attention
4.11.9 FreeBSD Matters needing attention
4.11.10 NetBSD Matters needing attention
4.11.11 Bsd/os Matters needing attention
4.11.11.1 Bsd/os 2.x precautions
4.11.11.2 Bsd/os 3.x Precautions
4.11.11.3 Bsd/os 4.x Precautions
4.11.12 SCO Considerations
4.11.13 SCO UnixWare 7.0 points of attention
4.11.14 Ibm-aix Matters needing attention
4.11.15 HP-UX Considerations
4.12 Win32 Matters needing attention
4.12.1 Install MySQL on Win32
4.12.2 to start MySQL on Win95/win98
4.12.3 to start MySQL on NT
4.12.4 running MySQL on Win32
4.12.5 connect a remote MySQL from Win32 with SSH
Comparison between 4.12.6 Mysql-win32 and Unix MySQL
4.13 OS/2 Matters needing attention
4.14 TcX Binary Code
4.15 Setup and test of post-installation (post-installation)
The problem of 4.15.1 running mysql_install_db
4.15.2 start the MySQL server problem
4.15.3 automatically start and stop MySQL
4.15.4 Options File
4.16 are there any special things to do when upgrading and demoting (downgrading)?
4.16.1 from a 3.22 version to 3.23
4.16.2 from a 3.21 version to 3.22
4.16.3 from a 3.20 version to 3.21
4.16.4 upgrades to other architectures
5 MySQL compatibility with the standard?
5.1 MySQL extensions to ANSI SQL92
5.2 Running MySQL in ANSI mode
5.3 MySQL is different than ANSI SQL92
5.4 MySQL lack of functionality
5.4.1 Sub-selection (sub-selects)
5.4.2 SELECT into TABLE
5.4.3 Services (Transactions)
5.4.4 stored procedures and triggers
5.4.5 FOREIGN key (Foreign keys)
5.4.5.1 reasons not to use foreign keys
5.4.6 View (views)
5.4.7 '--' as the beginning of an annotation
5.5 What standards does MySQL follow?
5.6 How to deal with no commit/rollback (Commit/rollback)
6 MySQL access rights system
6.1 What does the privilege system do?
6.2 MySQL user name and password
6.3 Connection to the MySQL server
6.4 Keep your password safe.
6.5 MySQL-Provided permissions
6.6 How the Privilege system works
6.7 access Control, Phase 1: Connection Confirmation
6.8 access Control, Phase 2: Request Confirmation
6.9 When permission changes take effect
6.10 Establish the initial MySQL permissions
6.11 Add new user rights to MySQL
6.12 How to set the password
6.13 Reasons for Access denied (Access Denied) error
6.14 How to make MySQL safe against the Decryption Master (cracker)
7 MySQL Language Reference
7.1 Text: How to write strings and numbers
7.1.1 string
7.1.2 Digital
7.1.36 Binary Value
7.1.4 Null value
7.1.5 database, table, index, column and alias name
7.1.5.1-Letter case Sensitivity
7.2 User Variables
7.3 Column types
Storage requirements for 7.3.1 column types
7.3.5 Numeric type
7.3.6 Date and Time type
7.3.6.1 Problem and Date type
7.3.6.2 datetime,date and timestamp types
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 Select the correct type for the column
7.3.9 Column Index
7.3.10 Multi-column index
7.3.11 using column types from other database engines
7.4 Functions used in the SELECT and WHERE clauses
7.4.1 Grouping functions
7.4.2 commonly used arithmetic operations
7.4.3-bit function
7.4.4 Logical operation
7.4.5 comparison operator
7.4.6 string comparison function
7.4.7 Type conversion operator
7.4.8 Control Flow function
7.4.9 Mathematical Functions
7.4.10 String function
7.4.11 Date and Time functions
7.4.12 other functions
7.4.13 functions used with the GROUP BY clause
7.5 Create DATABASE (creating databases) syntax
7.6 DROP db (Discard database) syntax
7.7 CREATE TABLE (creating tables) syntax
7.7.1 implied (silent) column specifies the change
7.8 ALTER TABLE (change tables) syntax
7.9 OPTIMIZE Table (optimized) syntax
7.10 DROP table (discard table) syntax
7.11 Delete (delete) syntax
7.12 Select (selected) syntax
7.13 Join (join) syntax
7.14 Insert (INSERT) syntax
7.15 replace (replace) syntax
7.16 Load Data INFILE (loaded to file) syntax
7.17 Update (UPDATE) syntax
7.18 use (using) syntax
7.19 FLUSH (Clear cache) syntax
7.20 Kill (Kill) syntax
7.21 Show (display) syntax (Get information about tables, columns, etc.)
7.22 EXPLAIN (interpretation) syntax (get information about Select)
7.23 DESCRIBE (description) syntax (get column information)
7.24 lock Tables/unlock Tables (lock table/Ching) syntax
7.25 Set option (SET options) syntax
7.26 Grant (Authorization) and revoke (recall) syntax
7.27 CREATE INDEX (indexed) syntax
7.28 DROP Index (discard index) syntax
7.29 annotation Syntax
7.30 Create Function/drop function (create functions/Discard functions) syntax
7.31 is MySQL very picky about reserved words?
8 MySQL Tutorial
8.1 Join and Disconnect servers
8.2 Input Query
8.3 Examples of common queries
Maximum value of 8.3.1 column
8.3.2 The row that owns the maximum value of a column
8.3.3 Column Maximum: By group: only values
8.3.4 a row with the largest number of groups in a field
8.3.5 using foreign keys
8.4 Create and use a database
8.4.1 Create and select a database
8.4.2 Create a database table
8.4.3 load data into a 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 a specific column
8.4.4.4 Sort Rows
8.4.4.5 Date Calculation
8.4.4.6 Null value operation
8.4.4.7 Pattern Matching
8.4.4.8 Row Count
8.4.5 Using multiple database tables
8.5 Access to database and table information
8.6 Using MySQL in batch mode
8.7 from the "dual-cell project" Query
8.7.1 Find all the twins who are not alone.
8.7.2 shows a table about the status of twins
9 MySQL Server Features
9.1 What languages does MySQL support?
9.1.1 the character set used for data and sorting
9.1.2 Add a new character set
9.1.3-Byte character support
9.2 Update Log
9.3 MySQL database table can have how large?
9.4 MySQL database table type
10 get maximum performance from MySQL
10.1 Optimization Overview
10.2 System/compile-time and start-up parameter adjustment
How 10.2.1 compilation and linking affect MySQL's speed
10.2.2 Disk Issues
10.2.2.1 use symbolic links for databases and tables
10.2.3 Tuning Server Parameters
10.2.4 how MySQL opens and closes database tables
10.2.5 The disadvantages of creating a large number of database tables in the same database
10.2.6 Why are there so many open tables?
10.2.7 how MySQL uses memory
10.2.8 How MySQL Locks database tables
10.2.9 database table-level locking problem
10.3 Make your data as small as possible
Use of 10.4 MySQL index
10.5 Query speed to access or update data
10.5.1 estimate Query Performance
10.5.2 the speed of a SELECT query
10.5.3 MySQL How to optimize WHERE clause
10.5.4 how MySQL optimizes left JOIN
10.5.5 MySQL How to optimize limit
10.5.6 the speed of an insert query
Speed of 10.5.7 update query
10.5.8 the speed of a delete query
10.6 Select a table type
Characteristics of 10.6.1 static (fixed length) table
Characteristics of 10.6.2 Dynamic table
Characteristics of 10.6.3 Compression table
Features of 10.6.4 memory (in-memory table) Table
10.7 Other Optimization Tips
10.8 Use your own benchmark test
10.9 Design Options
10.10 MySQL Design Limitations/tradeoffs
10.11 Portability
10.12 where are we using MySQL?
MySQL Benchmark Suite
MySQL Utilities
12.1 Overview of various MySQL programs
12.2 Manage a MySQL server
12.3 Inverted (dump) structure and data from MySQL database and tables
12.4 importing data from a text file
12.5 MySQL Compressed read-only table builder
13 Maintenance MySQL Installation
13.1 Use MYISAMCHK for table maintenance and crash recovery
Call syntax for 13.1.1 Myisamchk
Memory usage of 13.1.2 Myisamchk
13.2 13.2 Establish a database table maintenance specification
13.3 Getting information about a table
13.4 using Myisamchk for crash recovery
13.4.1 How to check the table for errors
13.4.2 How to fix the table
13.4.3 Table Optimization
13.5 Log file Maintenance
14 adding 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 values and error handling
14.1.4 Compile and install user-defined functions
14.2 Add a new native (native) function
15 Add new process for MySQL
15.1 Analyse process
15.2 writing a process
MySQL support for ODBC
Operating systems supported by 16.1 MYODBC
16.2 How to report MYODBC problems
16.3 programs that are known to work with MYODBC
16.4 How to fill in the various domains of the ODBC management program
16.5 How to obtain the value of a auto_increment column in ODBC
16.6 Report MYODBC issues
17 use MySQL with some common programs
17.1 Use MySQL with Apache
18 problems and common mistakes
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 the 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 How MySQL handles an overflow disk
18.4 How to run SQL commands from a text file
18.5 where is MySQL storing temporary files
18.6 How to Protect "/tmp/mysql.sock" is not deleted
18.7 Access denied error
18.8 How to run MySQL as a general user
18.9 How to reset a forgotten password
18.10 permission to file permissions issues
18.11 files are not found.
18.12 problems using the date column
18.13 Time Zone issues
18.14 Case Sensitivity in search
18.15 Null value problem
18.16 alias problem
18.17 Delete rows from related tables
18.18 Solve a problem with no matching rows
18.19 ALTER Table Problem
18.20 How to change the order of columns in a table
19 to solve some of the common MySQL problems
19.1 database replication
19.2 Database Backups
19.3 running multiple MySQL servers on the same machine
MySQL Customer Tools and APIs
20.1 MySQL C API
20.2 C API Data type
20.3 C API Functions 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_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 does Mysql_store_result () sometimes return null after mysql_query () returns success?
20.4.52 What results can I get from the query?
20.4.53 How can I get the unique ID of the last line inserted?
Problems with the 20.4.54 link C API
20.4.55 How to make a thread-safe (thread-safe) customer
20.5 MySQL Perl API
20.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 with other databases
21.1 How to compare MySQL and mSQL
21.1.1 How to convert the mSQL tool to MySQL
What is the difference between 21.1.2 mSQL and MySQL's client/server communication protocol
What is the difference between 21.1.3 msql 2.0 SQL syntax and MySQL?
21.2 How to compare MySQL with PostgreSQL
A some MySQL users
B Program of contribution
C MySQL Contributor
D The history of MySQL changes
E-known errors and design limitations in MySQL
F we want to join the MySQL schedule in the Future (TODO)
G. Instructions for porting to other systems
Description of the regular expression syntax of the H-MySQL
I What is Unireg?
J MySQL Server License for non-Microsoft operating systems
K MySQL License for Microsoft operating system
SQL commands, types, and function indexes
Concept Index

Responsible editor: Eight (2001-06-06-20:05)