get the difference between two tables in MySQL

table_difference.sql

SELECT table_name,
       column_name,
       ordinal_position,
       data_type,
       column_type,
       COLUMN_DEFAULT,
       COLUMN_COMMENT
FROM (SELECT table_name,
             column_name,
             ordinal_position,
             data_type,
             column_type,
             COLUMN_DEFAULT,
             COLUMN_COMMENT
      FROM information_schema.columns
      WHERE table_schema in ('message', 'data_archive')
        AND table_name IN ('message', '2022_message')
      GROUP BY column_name, ordinal_position,
               data_type, column_type, COLUMN_DEFAULT, COLUMN_COMMENT
      HAVING COUNT(1) = 1) A;