使用PHP获取MySQL插入的主键

Question

I have looked through the documentation for this, but it is all about auto-increment.

I generate a key using a trigger and MySQL's UUID() function (I need these keys to be unique across databases that may or may not ever interact).

I use a trigger to generate the UUID()

How would I retrieve that key on an insert?

Answer 1

Pass the UUID created by the trigger on a variable (@last_uuid)

CREATE TRIGGER ai_uuidtable
AFTER INSERT ON uuidtable
FOR EACH ROW
SET @last_uuid = NEW.uuid;

Then you can retrieve the value using a query

SELECT @last_uuid