56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT COUNT(*)
INTO @EXISTS
FROM information_schema.TABLES
WHERE table_schema = 'database'
AND table_name = 'tble';
SET @QUERY = IF(@EXISTS>0,
'RENAME TABLE tble TO tble_new',
'SELECT \'nothing to rename\' status');
PREPARE stmt FROM @QUERY;
EXECUTE stmt;
也实现不了,影响行总为0