Mysql 教程
时间：2006-08-30 来源：oychw
简介
1,Why Use MySQL?
快速,稳定,它是免费软件也是商业软件,支持transactions, row-level locking, foreign keys, subqueries, and full text searching. Version 5.0 will add stored procedures to the list.
易于安装使用,对系统要求低
2,Why MySQL Instead of Another Database?
性能,价格,功能的最佳结合.(一下略)
3,What's Different in 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.
目前公司所用的版本.4.0.21-standard
1,Why Use MySQL?
快速,稳定,它是免费软件也是商业软件,支持transactions, row-level locking, foreign keys, subqueries, and full text searching. Version 5.0 will add stored procedures to the list.
易于安装使用,对系统要求低
2,Why MySQL Instead of Another Database?
性能,价格,功能的最佳结合.(一下略)
3,What's Different in 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.
目前公司所用的版本.4.0.21-standard
The biggest change in version 5.0 is the addition of stored procedures, which have already been implemented in this pre-alpha. Other changes are also planned, including support for 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).
We will focus on five key areas: installing and configuring MySQL, designing and creating databases with MySQL, using MySQL, administering MySQL, and optimizing MySQL. We will cover all the core skills necessary to use MySQL on a professional basis.
第一部分:MYSQL 基础
Chapter 1. Installing MySQL
配置系统
做一下配置,
1,InnoDB
相关阅读 更多 +
