You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
526 B
28 lines
526 B
5 months ago
|
> 小孩子
|
||
|
|
|
||
|
|
# 第0章 楔子
|
||
|
|
|
||
|
|
我们都是小青蛙——公众号
|
||
|
|
|
||
|
|
# 第1章 初始MySQL
|
||
|
|
|
||
|
|
## 1.1 C/S架构
|
||
|
|
|
||
|
|
客户端/服务器
|
||
|
|
|
||
|
|
## 1.2 MySQL的安装
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
- 查询缓存已经在mysql8中被删除，我们可以使用redis做缓存
|
||
|
|
|
||
|
|
- 设置表的存储引擎/修改表引擎
|
||
|
|
|
||
|
|
```sql
|
||
|
|
CREATE TABLE 表名 (语句) ENGINE=存储引擎名;
|
||
|
|
|
||
|
|
CREATE TABLE table_a (name VARCHAR) ENGINE = MyISAM;
|
||
|
|
|
||
|
|
ALTER TABLE table_a ENGINE = InnoDB;
|
||
|
|
```
|