Compare Schema on Two Table

compare.sql

SELECT table_name,column_name,ordinal_position,data_type,column_type,column_default,
        is_nullable,
        CHARACTER_MAXIMUM_LENGTH,
        CHARACTER_OCTET_LENGTH,
        NUMERIC_PRECISION,
        NUMERIC_SCALE,
        DATETIME_PRECISION,
        CHARACTER_SET_NAME,
        COLLATION_NAME,
        EXTRA FROM
(
    SELECT
        table_name,
        column_name,
        ordinal_position,
        data_type,
        column_type,
        column_default,
        is_nullable,
        CHARACTER_MAXIMUM_LENGTH,
        CHARACTER_OCTET_LENGTH,
        NUMERIC_PRECISION,
        NUMERIC_SCALE,
        DATETIME_PRECISION,
        CHARACTER_SET_NAME,
        COLLATION_NAME,
        EXTRA,
        COUNT(1) rowcount
    FROM information_schema.columns
    WHERE table_schema=DATABASE()
    AND table_name IN ('v_listing','view_listing_temp')
    GROUP BY
        column_name,
        ordinal_position,
        data_type,
        column_type,
        column_default,
        is_nullable,
        CHARACTER_MAXIMUM_LENGTH,
        CHARACTER_OCTET_LENGTH,
        NUMERIC_PRECISION,
        NUMERIC_SCALE,
        DATETIME_PRECISION,
        CHARACTER_SET_NAME,
        COLLATION_NAME,
        EXTRA
    HAVING COUNT(1)=1
) A
order by ordinal_position asc, table_name asc