CodingForums.com - View Single Post

BubikolRamios · 12-19-2012, 12:02 PM

Code:

update t
set f =  UUID()
where id = 5

This will give for each record its own UUID
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 ?

12-19-2012, 12:02 PM	PM User \| #1
BubikolRamios Senior Coder Join Date: Dec 2005 Location: Slovenia Posts: 1,876 Thanks: 114 Thanked 76 Times in 76 Posts	variable into update Code: update t set f = UUID() where id = 5 This will give for each record its own UUID 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 ? __________________ Found a flower or bug and don't know what it is ? agrozoo.net galery if you don't spot search button at once, there is search form: agrozoo.net galery search