1、一种使用存储过程解决,结果,总是如下提示
Expression #3 of SELECT list is not in GROUP BY clause and contains n
2、使用 CONCAT 然后导出向导txt
SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO ', UPPER(table_name), ';' ) FROM information_schema.TABLES WHERE table_schema = 'gateway' ;
SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO ', LOWER(table_name), ';' ) FROM information_schema.TABLES WHERE table_schema = 'gateway' ;
这样复制出来执行
参考