2016-11-15 12:02 GMT+01:00 Simon Slavin <slav...@bigfraud.org>:
>
> On 15 Nov 2016, at 8:03am, Cecil Westerhof <cldwester...@gmail.com> wrote:
>
>> I have several tables where a numeric ID is used. I want to change
>> those to UUID's. Is there a smart way to do this, or need I to do this
>> one by one?
>
> I think you'll have to do it in software.

I thought so, but it never hurts to check.


> SQLite has a randomblob function which can be used to select part of the 
> UUID, but you need to pick a UUID scheme suitable for your purposes to know 
> how much of it can be random.

That is something to look into.

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to