【MySQL】检查表存在

 

    <select id="checkTableExists" resultType="java.util.Map">
        select count(*) as cnt
        from information_schema.tables
        where table_schema = database() and `table_name` = #{tableName}
    </select>