mysql - 如何使用MySQL检查数据库中是否已经存在表？

Question

现在我正在使用类似的东西:

dbResult = dbStatement.executeQuery("SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '[e2]' AND table_name = '[emp101_messages]'");
while(dbResult.next())
{
    int value = -1;
    value= dbResult.getInt(1);
    System.out.println(value + " table count");
}

这是检查数据库中是否存在表的正确方法吗？

Answer 1

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'dbname'
  AND table_name = 'my_tablename';

+----------------------+
| table_name           |
+----------------------+
| my_tablename |
+----------------------+

因为大多数选项已经提供。请看看这是否有帮助。