《Mysql学习手册》项目与实践教研室版本1.0文档提供:项目与实践教研室文档编号PAP-01-01项目编号Mysql学习手册文档属性项目明细文档标题Mysql学习手册整理人臧永娜创建日期2008-9-10最后修改日期修订历史记录版本日期AMD修订者说明1.02008-09-10A臧永娜(A-添加,M-修改,D-删除)目录第一章Mysql在Windows上安装............................................................................................4第一节安装环境..............................................................................................................4第二节Mysql版本和程序包............................................................................................4第三节具体安装步骤.......................................................................................................5第四节Mysql服务启动..................................................................................................20第二章Mysql常用配置..........................................................................................................21第一节Mysql命令行客户端配置数据库......................................................................211.登陆Mysql数据库.................................................................................................21第二节Mysql客户端工具..............................................................................................221.MySQL-Front的安装..............................................................................................232.创建用户................................................................................................................293.数据表的基本操作.................................................................................................31第三章Mysql实验..................................................................................................................37第一节实验一创建数据库............................................................................................38第二节实验二创建用户................................................................................................39第三节实验三创建表....................................................................................................40第四节实验四增加主键................................................................................................41第五节实验五插入记录...............................................................................................42第六节实验六更新记录...............................................................................................44第七节实验七删除记录...............................................................................................45第八节实验八单表查询................................................................................................46第九节实验九分组查询................................................................................................47第十节实验十联合查询...............................................................................................48第十一节实验十一查询平均分....................................................................................49第十二节实验十二联合查询排序...............................................................................50第十三节实验十三联合查询最大值、最小值...........................................................51第十四节实验十四...