今天聊點不一樣的東西，有點不起眼卻很重要的小玩意：UUID (或是微軟的GUID)。 ... 有順序的UUID 除了排序時方便，在當作MySQL 的主鍵(primary key)， ... 閒...

UUID as Primary Key. 22 March 2014. 最近有個小小專案，該專案用PostgreSQL，該案按照我們新專案的慣例，採用UUID 當做主鍵，而不是用資料庫自動產生的...

What is UUID? UUIDs stands for Universally Unique Identifiers, used to uniquely identify the tabl...

What I always do, even if it's redundant is I create primary key ... CREATE TABLE users( pk INT N...

The clustered index orders the rows automatically by the primary key. When you insert a new row w...

By using UUID, you can generate the primary key value of the parent table up front and insert row...