MySql5.0中文使用手册资源-CSDN下载

共59个文件

htm：40个

png：19个

MySql

使用手册

4星 · 超过85%的资源需积分: 19 67 浏览量 2008-09-01 09:49:35 上传评论收藏 2.23MB RAR 举报

MySQL 5.0 是一款广泛使用的开源关系型数据库管理系统，其功能强大且易于学习，尤其适合初学者和专业开发者。本手册将详细讲解MySQL 5.0的核心概念、安装配置、基本操作以及高级特性，旨在帮助用户快速掌握并熟练运用MySQL。让我们了解MySQL的基础知识。MySQL基于SQL（结构化查询语言），这是用于管理和操作数据库的标准语言。SQL允许用户创建、查询、更新和删除数据，以及管理数据库结构。在MySQL 5.0中，你可以创建各种类型的数据库对象，如表、视图、索引、存储过程和触发器。安装MySQL 5.0通常包括下载安装包，配置服务器设置，设置用户权限，以及启动和停止服务。在Windows上，可以通过图形界面进行安装；在Linux或Unix系统中，通常使用命令行工具进行配置。在掌握了基础安装步骤后，你需要了解如何连接到MySQL服务器。这通常通过MySQL客户端完成，比如`mysql`命令行工具或者MySQL Workbench。连接时需要提供用户名、密码和服务器地址。一旦连接成功，你就可以开始编写SQL语句来与数据库交互。创建数据库是MySQL中的第一步，使用`CREATE DATABASE`语句。然后，可以使用`USE`语句切换到特定的数据库。接下来，设计表结构是关键，使用`CREATE TABLE`定义字段名、数据类型、约束条件等。例如： ```sql CREATE TABLE Employees ( ID INT PRIMARY KEY, Name VARCHAR(50), Age INT, Position VARCHAR(50) ); ``` 插入数据用`INSERT INTO`语句，查询数据则用`SELECT`语句，这是SQL最常用的两个操作。例如，查询所有员工信息： ```sql SELECT * FROM Employees; ``` 更新数据用`UPDATE`，删除数据用`DELETE`。同时，MySQL还支持JOIN操作，用于合并多个表的数据，以及子查询、聚合函数（如COUNT、SUM、AVG）和分组（GROUP BY）等高级查询技术。索引是提升查询性能的重要手段，MySQL支持多种类型的索引，如B树索引、哈希索引和全文索引。使用`ALTER TABLE`语句可以添加、修改或删除索引。此外，MySQL 5.0引入了视图和存储过程，视图可以理解为虚拟表，它是对已有查询结果的保存；存储过程是一组预编译的SQL语句，可提高代码复用性和安全性。事务处理在数据库操作中也至关重要，MySQL支持ACID（原子性、一致性、隔离性、持久性）特性，确保数据的一致性。你可以使用`START TRANSACTION`、`COMMIT`和`ROLLBACK`来管理事务。安全管理是任何数据库系统的核心部分。MySQL提供了用户权限系统，可以控制用户对数据库的访问级别，如GRANT和REVOKE语句用于赋予和撤销权限。 MySQL 5.0中文使用手册将涵盖这些内容，并通过实例帮助你理解和应用这些知识。无论是新手还是有经验的开发者，都可以从中受益，提升数据库管理技能。通过深入学习和实践，你将能够自如地在MySQL 5.0环境中构建、管理及优化数据库系统。

资源推荐

资源详情

资源评论

收起资源包目录

MySql5.0中文使用手册.rar （59个子文件）

MySql5.0使用手册

Chapter 12_ Functions and Operators.htm 327KB

Chapter 26_ Connectors.files

myaccess.png 125KB

mydsn-icon.png 3KB

mydll-properties.png 11KB

mydsn-test-fail.png 7KB

myflowchart.png 27KB

mydsn.png 105KB

mydsn-test-success.png 7KB

myarchitecture.png 8KB

mydsn-example.png 15KB

mydsn-setup.png 15KB

myaccess-odbc.png 18KB

mydsn-trace.png 110KB

mydsn-options.png 15KB

Chapter 20_ Stored Procedures and Functions.htm 82KB

Chapter 8_ Client and Utility Programs.htm 208KB

Chapter 1_ General Information.htm 168KB

Chapter 9_ Language Structure.htm 65KB

Appendix E_ Porting to Other Systems.htm 44KB

Chapter 27_ Extending MySQL.htm 58KB

Chapter 7_ Optimization.htm 347KB

Chapter 21_ Triggers.htm 24KB

Appendix D_ MySQL Change History.htm 9KB

Chapter 2_ Installing MySQL.htm 560KB

Chapter 17_ MySQL Cluster.htm 335KB

Appendix I_ Feature Restrictions.htm 25KB

Chapter 17_ MySQL Cluster.files

cluster-components-1.png 73KB

multi-comp-1.png 42KB

Chapter 16_ Writing a Custom Storage Engine.files

custom-engine-overview.png 212KB

Chapter 19_ Spatial Extensions in MySQL.htm 125KB

Chapter 10_ Character Set Support.htm 127KB

Chapter 11_ Column Types.htm 129KB

Appendix J_ GNU General Public License.htm 18KB

Chapter 4_ Using MySQL Programs.htm 41KB

Chapter 14_ Pluggable Storage Engine Architecture.htm 16KB

MySQL 5_1 Reference Manual.htm 148KB

Chapter 16_ Writing a Custom Storage Engine.htm 102KB

Chapter 14_ Pluggable Storage Engine Architecture.files

pluggable-storage-overview.png 86KB

pluggable-storage-choosing.png 51KB

Appendix B_ Error Codes and Messages.htm 152KB

Chapter 3_ Tutorial.htm 150KB

Chapter 15_ Storage Engines and Table Types.files

blackhole-1.png 25KB

Chapter 13_ SQL Statement Syntax.htm 618KB

Chapter 26_ Connectors.htm 764KB

Chapter 15_ Storage Engines and Table Types.htm 376KB

Appendix K_ MySQL FLOSS License Exception.htm 10KB

Appendix C_ Credits.htm 56KB

Chapter 5_ Database Administration.htm 798KB

Appendix G_ MySQL Regular Expressions.htm 18KB

Appendix F_ Environment Variables.htm 6KB

Chapter 18_ Partitioning.htm 127KB

Appendix A_ Problems and Common Errors.htm 158KB

MySql5.0使用手册.htm 168KB

Chapter 22_ Views.htm 26KB

Index.htm 354KB

Chapter 6_ Replication in MySQL.htm 144KB

Chapter 24_ Precision Math.htm 36KB

Chapter 23_ The INFORMATION_SCHEMA Information Database.htm 81KB

Chapter 25_ APIs and Libraries.htm 381KB

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">  <HTML><HEAD><TITLE>Chapter 5. Database Administration</TITLE> <META http-equiv=Content-Type content="text/html; charset=utf-8"> <META content="MSHTML 6.00.2900.3020" name=GENERATOR><LINK title="MySQL 5.1 Reference Manual" href="index.html" rel=start><LINK title="MySQL 5.1 Reference Manual" href="index.html" rel=up><LINK title="Chapter 4. Using MySQL Programs" href="using-mysql-programs.html" rel=prev><LINK title="Chapter 6. Replication in MySQL" href="replication.html" rel=next></HEAD> <BODY> <DIV class=chapter> <DIV class=titlepage> <DIV> <DIV> <H2 class=title><A name=database-administration></A>第5章：数据库管理</H2></DIV></DIV></DIV> <DIV class=toc> 目录 <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-side-scripts">5.1. MySQL服务器和服务器启动脚本</A> <DD> <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-side-overview">5.1.1. 服务器端脚本和实用工具概述</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#mysqld-max">5.1.2. mysqld-max扩展MySQL服务器</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#mysqld-safe">5.1.3. mysqld_safe：MySQL服务器启动脚本</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#mysql-server">5.1.4. mysql.server：MySQL服务器启动脚本</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#mysqld-multi">5.1.5. mysqld_multi：管理多个MySQL服务器的程序</A></DT></DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#instance-manager">5.2. mysqlmanager：MySQL实例管理器</A> <DD> <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#instance-manager-startup-process">5.2.1. 用MySQL实例管理器启动MySQL服务器</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#instance-manager-security">5.2.2. 连接到MySQL实例管理器并创建用户账户</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#instance-manager-command-line-options">5.2.3. MySQL实例管理器命令行选项</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#instance-manager-configuration-files">5.2.4. MySQL实例管理器配置文件</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#instance-manager-commands">5.2.5. MySQL实例管理器识别的命令</A></DT></DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#mysqld">5.3. mysqld：MySQL服务器</A> <DD> <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-options">5.3.1. mysqld命令行选项</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-sql-mode">5.3.2. SQL服务器模式</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-system-variables">5.3.3. 服务器系统变量</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-status-variables">5.3.4. 服务器状态变量</A></DT></DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#mysql-fix-privilege-tables">5.4. mysql_fix_privilege_tables：升级MySQL系统表</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#server-shutdown">5.5. MySQL服务器关机进程</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#security">5.6. 一般安全问题</A> <DD> <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#security-guidelines">5.6.1. 通用安全指南</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#security-against-attack">5.6.2. 使MySQL在攻击者面前保持安全</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#privileges-options">5.6.3. Mysqld安全相关启动选项</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#load-data-local">5.6.4. LOAD DATA LOCAL安全问题<CODE class=literal></CODE></A></DT></DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#privilege-system">5.7. MySQL访问权限系统</A> <DD> <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#what-privileges">5.7.1. 权限系统的作用</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#privileges">5.7.2. 权限系统工作原理</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#privileges-provided">5.7.3. MySQL提供的权限</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#connecting">5.7.4. 与MySQL服务器连接</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#connection-access">5.7.5. 访问控制, 阶段1：连接核实</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#request-access">5.7.6. 访问控制, 阶段2：请求核实</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#privilege-changes">5.7.7. 权限更改何时生效</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#access-denied">5.7.8. 拒绝访问错误的原因<CODE class=literal></CODE></A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#password-hashing">5.7.9. MySQL 4.1中的密码哈希处理</A></DT></DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#user-account-management">5.8. MySQL用户账户管理</A> <DD> <DL> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#user-names">5.8.1. MySQL用户名和密码</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administration.html#adding-users">5.8.2. 向MySQL增加新用户账户</A> <DT><A href="http://www.hdut.com/help/mysql5.1/database-administratio

评论收藏

内容反馈