Hello! В сообщении от Wednesday 26 November 2008 22:37:19 Brown, Daniel написал(а): > Is there any functionality built into SQLite to generate CRC values for > tables? We would like to be able to verify that the contents of the > table we just updated matches the intended contents. Currently using > our old database solution we generate a CRC value for each table and > compare them. Is there similar functionality in SQLite?
For table rows: select md5sum(*) from mytable; (md5 hash) For table values: select md5sum(value) from mytable; (md5 hash) For single value: select md5(value) from mytable; (md5 hash 1) (md5 hash 2) (md5 hash ...) Functions md5sum and md5 is realised in my extensions and you can find this in archive of the maillist. Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
