更新时间:2023-11-24 12:52:16
Doc 说
表的主键表示一列或一组列您在最重要的查询中使用的.它有一个关联的索引,以实现快速查询性能.查询性能受益于 NOTNULL 优化,因为它不能包含任何 NULL 值.随着InnoDB 存储引擎,表数据是物理组织起来的基于主键列的超快速查找和排序或列.
The primary key for a table represents the column or set of columns that you use in your most vital queries. It has an associated index, for fast query performance. Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or columns.