Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
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?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

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

checksum-table

Similar questions
E
est_b2015-07-07 21:45:15
What to read in C for familiarization? 3Reply
N
Nikolai Steshenko2021-05-24 00:59:15
How to add a field to registration or remove instantaCms? 2Reply
N
Norwood2019-12-07 00:29:47
Why does the underline on a link shrink? 3Reply
E
Eugene2019-12-19 01:12:07
How to initialize an empty variable? 4Reply
L
Lulzsec2015-08-23 18:52:12
Telegram Webhook does not send requests to an address with HTTPS (code attached), what's the problem? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question