mysql uuid varchar,MySQL中的主键：INT（n）或UUID为varchar（36）

Does it make sense to use UUID as primary key in MySQL?

What would be pros and cons of using UUID instead of regular INT, beside trouble of hand querying?

解决方案

The major downside of UUIDs is that you have to create them beforehand if you want to refer back to the record for further usage afterwards (ie: adding child records in dependent foreign keyed tables):

INSERT INTO table (uuidfield, someotherfield) VALUES (uuid(), 'test'));

will not let you see what the new UUID value is, and since you're not using a regular auto_incremented primary key, you can't use last_insert_id() to retrieve it. You'd have to do it in a two-step process:

SELECT @newuid := uuid();

INSERT INTO table (uuidfield, someotherfield) VALUES (@newuid, 'test');

INSERT INTO childtable ..... VALUES (@newuid, ....);