Checksum of SELECT results in MySQL -
trying check sum of results of select statement, tried this
select sum(crc32(column_one)) database.table;
which worked, did not work:
select concat(sum(crc32(column_one)),sum(crc32(column_two))) database.table;
open suggestions, main idea valid checksum sum of results of rows , columns select statement.
the problem concat
, sum
not compatible in format.
concat
designed run once per row in result set on arguments defined row.
sum
aggregate function, designed run on full result set.
crc32
of same class of functions concat
.
so, you've got functions nested in way don't play nicely together.
you try:
select concat( (select sum(crc32(column_one)) database.table), (select sum(crc32(column_two)) database.table) );
or
select sum(crc32(column_one)), sum(crc32(column_two)) database.table;
and concatenate them client language.
Comments
Post a Comment