MySQL判斷表名是否存在

邢帅杰發表於2024-08-19
SELECT COUNT(1) FROM INFORMATION_SCHEMA.Columns WHERE TABLE_SCHEMA='DataBaseName' AND TABLE_NAME='TableName';
SHOW TABLES LIKE 'TableName';

相關文章