mysql table definition md5

TableMd5.java

    private String md5(String table) {
        String columnDefinitionSql = "SELECT column_name,ordinal_position,column_default,is_nullable,column_type\n" +
                "FROM information_schema.columns\n" +
                "WHERE table_schema = '%s' AND table_name = '%s' order by column_name";

        MessageDigest md5 = DigestUtils.getMd5Digest();
        jdbcTemplate.query(String.format(columnDefinitionSql, dbSchema, table), row -> {
            ResultSetMetaData meta = row.getMetaData();
            int cols = meta.getColumnCount();
            for (int i = 1; i <= cols; i++) {
                md5.update(meta.getColumnName(i).getBytes());
                Object val = row.getObject(i);
                if (val != null)
                    md5.update(val.toString().getBytes());
            }
        });

        return Hex.encodeHexString(md5.digest());
    }