判断表是不是存在

判断表是否存在select count(*) from information_schema.tables where table_schema 数据库名 and ta

判断表是否存在
select count(*) from information_schema.tables where table_schema = '数据库名' and table_name = '表名';