MySQL存储过程：如何检查表是否存在 - 代码示例

{/'title/':/'MySQL存储过程：如何检查表是否存在 - 代码示例/',/'description/':/'本文介绍如何使用MySQL存储过程检查表是否存在，并提供详细代码示例和使用方法。/',/'keywords/':/'MySQL, 存储过程, 表是否存在, 检查, 代码示例, database, table, exists, procedure/',/'content/':/'///'要查询MySQL中是否存在某个表，可以使用以下存储过程：////n////nmysql////nDELIMITER //////n////nCREATE PROCEDURE table_exists(IN db_name VARCHAR(255), IN table_name VARCHAR(255))////nBEGIN////n DECLARE table_count INT;////n ////n SELECT COUNT(*) INTO table_count////n FROM information_schema.tables////n WHERE table_schema = db_name////n AND table_name = table_name;////n ////n IF table_count > 0 THEN////n SELECT 'Table exists' AS result;////n ELSE////n SELECT 'Table does not exist' AS result;////n END IF;////nEND //////n////nDELIMITER ;////n////n////n然后，可以调用该存储过程来查询表是否存在：////n////nmysql////nCALL table_exists('your_database_name', 'your_table_name');////n////n////n请替换your_database_name和your_table_name为实际的数据库名和表名。调用存储过程后，将返回///'Table exists///'或///'Table does not exist///'的结果。///