Create a custom function MD5 ,
Custum_uuid() -> MD5(table_name || Numeric_ID || "salt string" )
Update table tab1 set id= md5('tab1' || '$' || ID || '$' || 'My custom string')
Update table tab1 set ref_id= md5('tab2' || '$' || ref_id || '$' || 'My custom
string')
发自我的 Windows Phone
________________________________
发件人: Cecil Westerhof<mailto:[email protected]>
发送时间: 2016/11/15 16:03
收件人: SQLite mailing list<mailto:[email protected]>
主题: [sqlite] Changing ID's to UUID
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?
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
