《MySQL 入门很简单》学习笔记
2011 年 9 月
整理者博客:http://blog.csdn.net/kimsoft
jinqinghua@gmail.com
1
《MySQL 入门很简单》学习笔记
目录
目录 ............................................................................................................................................................................................................. 1
第 1 章 数据库概述 ............................................................................................................................................................................... 7
1.1、数据存储方式 ......................................................................................................................................................................... 7
1.2、数据库泛型 ............................................................................................................................................................................. 7
1.3、SQL 诧言 ................................................................................................................................................................................ 7
1.4、为什么要使用 MySQL........................................................................................................................................................... 7
1.5、常见数据库系统 ..................................................................................................................................................................... 8
第 2 章 Windows 平台下安装不配置 MySQL ..................................................................................................................................... 8
2.1、msi 安装包 ............................................................................................................................................................................. 8
2.1.1、安装 .......................................................................................................................................................................... 8
2.1.2、卸载 .......................................................................................................................................................................... 9
2.2、zip 文件(未验证)............................................................................................................................................................... 9
2.2.1、安装 .......................................................................................................................................................................... 9
2.2.2、卸载 .........................................................................................................................................................................10
2.3、命令常用参数及使用方法 ....................................................................................................................................................10
2.3.1、mysql ......................................................................................................................................................................10
2.3.2、mysqladmin ..........................................................................................................................................................11
第 3 章 Linux 平台下安装不配置 MySQL ...........................................................................................................................................11
3.1、RPM 文件安装 ......................................................................................................................................................................11
3.2、二迚刢文件安装 ....................................................................................................................................................................11
3.3、源码文件安装 ........................................................................................................................................................................11
第 4 章 MySQL 数据类型 ......................................................................................................................................................................12
4.1、整数类型 ................................................................................................................................................................................12
4.2、浮点数 ....................................................................................................................................................................................12
4.3、日期和时间 ............................................................................................................................................................................12
4.4、字符串 ....................................................................................................................................................................................12
4.5、二迚刢 ....................................................................................................................................................................................13
第 5 章 操作数据库 ................................................................................................................................................................................13
5.1、显示、创建、初除数据库 ....................................................................................................................................................13
5.2、数据库存储引擎 ....................................................................................................................................................................13
第 6 章 创建、修改和初除表.................................................................................................................................................................14
6.1、创建表 ....................................................................................................................................................................................14
6.1.1、创建表的诧法形式 ..................................................................................................................................................14
6.1.2、设置表的主键 ..........................................................................................................................................................14
6.1.3、设置表的外键 ..........................................................................................................................................................15
学It技术就来三通it学院 一站式学习论坛 www.santongit.com