Home > Database > Mysql Tutorial > mysql引擎_MySQL

mysql引擎_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:16:15
Original
1022 people have browsed it

InnoDB是Mysq的表提供事务、回滚、崩溃修复能力和多版本并发控制的事务安全。

MyIsAm存储引擎是Mysql中常见的存储引擎。

Memory存储引擎所有的数据都存在内存中。速度快,但安全性不高。

default-character-set = utf8

character-set-server = utf8

设置表的主键:

单个主键

1. primary key

多个主键

2. primary key(one,two)

设置表的外键

contraint 外键别名 foreign key(one,two,three….) references 表名(one,two,three)

前者和后者类型要一致,后者必须是主键

设置表的非空约束

not null

null

设置表的唯一约束

unique

设置表的属性自动增加

auto_increment

设置表的属性的默认值

default “dd”

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template