MYSQL 教程 §0 介绍

书目

英文原名:      MySQL® Tutorial

作者       :      Luke Welling, Laura Thomson

出版商    :     Sams Publishing

出版日期:     November 04, 2003

ISBN : 0-672-32584-5

Pages : 300

简介

       MySQL Tutorial 包含一系列短小,简练,目标性强的章节,每章都易学易消化，可独立阅读。主要包含了以下五个方面:

＊     安装和配置

＊     使用MYSQL

＊     管理MYSQL

＊     优化MYSQL

＊     MYSQL相关的API

本书的介绍：http://www.informit.com/store/product.aspx?isbn=0672325845

里面有源码下载

其他的一些信息：www.lukelaura.com.

§0    介绍

本章主要内容：

• Why use MySQL?
• Why MySQL instead of another database?
• What's different in MySQL 4.0 and 4.1?
• What features are still to come in future versions?
• Who should read this book?
• How this book works
• A note on MySQL licensing

§0.1 为什么使用MYSQL？

MYSQL快速,稳定,它是免费软件也是商业软件,支持transactions, row-level locking, foreign keys, subqueries, 一级 full text searching. 5.0将支持存储过程.
易于安装使用,对系统要求低

§0.2 为什么MYSQL会替代其他数据库？

性能,价格,功能的最佳结合(具体请参见原文)。性能优越，价格便宜，稳定，易于使用。

MySQL 4.1 offers

·         ACID-compliant transactions

·         Cross-platform support

·         Replication

·         Support for huge tables and databases

·         Full text search

·         Subqueries

·         Support for most SQL 92 syntax

MySQL does not currently include

·                     Views

·                     Stored procedures

·                     Triggers

§0.3  MySQL 4.0 and 4.1的区别

长期以来MySQL 3.23 是最新版本,2003-04,MySQL 4.0.13 发布,跟以前的版本有以下区别

a,The InnoDB engine is ACID compliant, supporting transactions, foreign keys, and row-level locking.
b,MySQL now uses a query cache, storing the results returned by queries for later reuse and, hence, greatly improving performance for common queries.
c,Full-text indexing and searching, which were added in 3.23.23, have been improved with the addition of Boolean mode.
d,MERGE tables now support INSERT and AUTO_INCREMENT.
e,The result sets from SELECT queries can now be merged with UNION.
f,You can now delete rows from multiple tables with a single DELETE statement.
g,User privilege management has been refined. More privileges have been added to give you a finer grain of control, and you can also now limit a user's resource use.
h,You can now make changes to server configuration without having to restart the server.
i,A new C language library, libmysqld, is now available to allow you to embed MySQL servers in your programs.
j,Replication, which has been available since 3.23.15, has been improved in various ways, mostly bug fixes. For example, you can now set up a slave using LOAD DATA FROM MASTER, rather than having to use mysqldump or a tool like mysqlsnapshot.
In 4.1, there are some additional improvements. The most important change is the addition of subqueries and derived tables. You also get Unicode support, support for OpenGIS geographical data storage, and a host of other minor improvements.

§0.4  MySQL 即将增加的功能

目前公司所用的版本.4.0.21-standard, 5.0将支持存储过程，cursors, RTREE indexes, true VARCHARs, and a host of other minor features.

Version 5.1 should support foreign keys for all table types (among a host of other features). Views should be supported in one of the 5.x versions.

§0.5  其他

多数mysql 源码遵循GPL

GPL        http://www.gnu.org/licenses/

http://www.gnu.org/licenses/gpl-faq.html

If this does not suit your purposes—if, for example, you want to modify MySQL and sell the modified binary without access to the source code—you must purchase a commercial license from MySQL AB. You can also choose to purchase a commercial license from MySQL AB if you want to support the development of MySQL.

One important note is that the MySQL documentation is not available under the GPL, but it can be printed for personal use.

§0.6 参考资料

Mysql基准     http://www.mysql.com/why-mysql/benchmarks/

Mysql下载     www.mysql.com/downloads/index.html

第1部分, MYSQL基础

  1 Installing MySQL

2 Quick Tour