variable into update
This will give for each record its own UUID
set f = UUID()
where id = 5
I want same UUID for each record !
I know how to do it in two separate sql-s, but I'm almost sure that could be done with one sql only (creating & using varaible inside sql).
How to do it, if possible ?
Well, I don't know how to do it in one query, but I know how to do it all in a single operation.
As you know, I don't use PHP. That code will work from the MySQL command line or from a MySQL query issued via JSP or ASP or ASP.NET code. But I understand that PHP does not allow multiple MySQL queries per call to mysql_query( ) so I don't know how you would do it with PHP.
SET @u = UUID(); UPDATE t SET f = @u WHERE id = 5;