本文介绍了您何时应该选择在MySQL中使用InnoDB?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

此处让我感到困惑. >

I am rather confused by the hurt-mongering here.

我知道该怎么做,见下文,但不知道为什么?他们是干什么的?

I know how to do them, see below, but no idea why? What are they for?

create table orders (order_no int not null auto_increment, FK_cust_no int not null, 
foreign key(FK_cust_no) references customer(cust_no), primary key(order_no)) type=InnoDB;


create table orders (order_no int not null auto_increment, FK_cust_no int not null, 
foreign key(FK_cust_no) references customer(cust_no), primary key(order_no));

推荐答案

InnoDB是 MySQL中的存储引擎.其中有很多,而且各有优缺点. InnoDB的最大优势是:

InnoDB is a storage engine in MySQL. There are quite a few of them, and they all have their pros and cons. InnoDB's greatest strengths are:

  • 支持交易(为您提供 ACID 属性的支持).
  • 行级锁定.与例如 MyISAM .
  • 外键约束.允许您让数据库确保数据库状态以及表之间关系的完整性.
  • Support for transactions (giving you support for the ACID property).
  • Row-level locking. Having a more fine grained locking-mechanism gives you higher concurrency compared to, for instance, MyISAM.
  • Foreign key constraints. Allowing you to let the database ensure the integrity of the state of the database, and the relationships between tables.

这篇关于您何时应该选择在MySQL中使用InnoDB?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-23 19:28