M
M
Max Ba2020-04-24 08:59:39
MySQL
Max Ba, 2020-04-24 08:59:39

How to calculate the hash of all strings?

Usually, to check the integrity, I used
SHA1(CONCAT(`col1`, `col2`, `col3`))
But I would like to get a hash of ALL rows from the database.

So far, I have solved the issue using php, where the array is filled with strings and a hash is created.

Can this somehow be done using just mysql?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
xmoonlight, 2020-04-24
@phpcoder81

checksum-table

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question