mysql uuid 返回,mysql_insert_id或类似的东西返回最后一个mysql UUID（）

How do you return the last generated UUID() (primary key) - is there something like mysql_insert_id for that?

Table uuidtable:

primary key: uuid uuid()

id_u (index): integer

multiple id_u matched with a primary key uuid()

insert: insert into uuidtable (uuid,id_u) values (uuid(),id)

where id is a number, of course, and uuid is escaped withuuid

解决方案

Write yourself a trigger like so:

CREATE TRIGGER ai_uuidtable

AFTER INSERT ON uuidtable

FOR EACH ROW

SET @last_uuid = NEW.uuid;

Following an insert:

SELECT @last_uuid

MySQL's user-defined variables are connection-specific, so you don't have to worry about getting another connection's @last_uuid.

One point of concern: If you're using the uuid as a key, in order for it to be maximally performant, it should be stored as a 16-byte binary field and not a 36-byte char field. If you really want to use MySQL's UUID() algorithm, strip out the hyphens and UNHEX() it:

UNHEX( REPLACE( UUID(), '-', '' ) )

Aside: PostgreSQL actually has a UUID data type (but no built-in UUID() function), which just means you don't have to re-HEX() the field in order to avoid getting binary garbage in your terminal on SELECT.