January 9 2017

mysql db rename

SELECT concat(‘rename table loanbiz.’,TABLE_NAME,’ to acrc.’,TABLE_NAME,’;’) FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=’loanbiz’ into outfile ‘/tmp/a.sql’;



Copyright 2019. All rights reserved.

Posted 2017年1月9日 by ucjmh in category "未分类

Leave a Reply

Your email address will not be published. Required fields are marked *