mysql - Get the generated uuid after insert php

Question

i have a table field type varchar(36) and i want to generate it dynamically by mysql so i used this code:

$sql_code = 'insert into table1 (id, text) values (uuid(),'some text');';
mysql_query($sql_code);

how can i retrieve the generated uuid immediately after inserting the record ?

Answer 1

1. char(36) is better

2. you cannot. The only solution is to perform 2 separated queries:

   • SELECT UUID()
   • INSERT INTO table1 (id, text) VALUES ($uuid, 'text')

where $uuid is the value retrieved on the 1st step.