I have to create a checksum column in the midst of running an insert statement (its a short term fix), and I would rather not have to hash a very wide table (400 columns). Is there any way to select or get all the columns from a table (and filter out a few) as a subquery and hash that rather than list each column in my query?

As a query using "show" does not work inline

select column_name from (
show columns in  table my.example.table)
where column_name not like 'example%'
;

CodePudding user response：

It is possible to compute hash value without specifying column list using