mysql 判断是否存在_mysql判断是否存在表

1、在Yii2框架中判断数据表是否存在。

private static function checkTable($table){

$sql = "SHOW TABLES LIKE '". $table."'";

$existTable = static::findBySql($sql)->asArray()->one();

if(empty($existTable)){

return 0;

}

return 1;

}

2、在php中判断数据表是否存在。

$dsn = 'mysql:dbname=test;host=127.0.0.1';

$user = 'root';

$password = '';

try {

$pdo = new PDO($dsn, $user, $password);

} catch (PDOException $e) {

die("数据库连接失败".$e->getMessage());

}

$table = 'cy_news';

//判断表是否存在

$result = $pdo->query("SHOW TABLES LIKE '". $table."'");

$row = $result->fetchAll();

if('1' == count($row)){

echo "Table exists";

} else {

echo "Table does not exist";

}

?>

$con = mysql_connect("localhost","root","");

mysql_select_db("php_cms", $con);

$table = 'cy_news';

if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '". $table."'"))==1) {

echo "Table exists";

} else {

echo "Table does not exist";

}