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:cldwester...@gmail.com> 发送时间: 2016/11/15 16:03 收件人: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> 主题: [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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users