請參考PHP代碼，檢測表user是否存在：

$table = 'user'
$tables = $pdo->query("show tables")->fetchAll(PDO::FETCH_GROUP);
if ( in_array($table, array_keys($tables)) ) { 
    echo 'table exists';
} else {
    echo 'table not found';
}

一.SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'table_name' AND TABLE_SCHEMA = 'db_name'

二. CREATE TABLE IF NOT EXISTS table_name (....);

CREATE TABLE IF NOT EXISTS TEST(
id int primary key auto_increment
);

或者可以通過show tables獲取數(shù)據(jù)庫所有表，然后遍歷