Mysql：如果存在则重命名表

我设法执行了一个始终有效的代码，并且当表不存在时也不会产生错误：

SELECt Count(*)INTO @existsFROM information_schema.tables WHERe table_schema = [DATAbase_NAME]    AND table_type = 'base TABLE'    AND table_name = 'video_top_day';SET @query = If(@exists>0,    'RENAME TABLE video_top_day TO video_top_day_for_delete',    'SELECT 'nothing to rename' status');PREPARE stmt FROM @query;EXECUTE stmt;

当您不想

[DATAbase NAME]

SELECt DATAbase() INTO @db_name FROM DUAL;