[求助]请问Yii怎么判断一个数据库表是否存在 [ 未指定版本 ]

$sql = 'SHOW TABLES LIKE {{不存在的表名}}';
$p = Yii::app()->db->createCommand($sql)->queryAll();

直接报错

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tbl_xxxx' at line 1. The SQL statement executed was: SHOW TABLES LIKE tbl_xxxx

好了，符号弄错了

$sql = 'SHOW TABLES LIKE  \'%{{xxxx}}%\'';
$sql = 'SELECT COUNT( * ) FROM information_schema.TABLES WHERE TABLE_NAME =  \'{{xxxx}}\'';