aaa1_1aaa的博客

1、执行sql ,生成批量sql语句;SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO qb', substring(table_name,6),';' )     FROM information_schema.tables  WHERE table_name LIKE 'tplay%';  #qb 为你修改后的前缀 # ...

[client]port=3306[mysql]default-character-set=utf8[mysqld]port=3306basedir="D:/phpStudy2018/PHPTutorial/MySQL/"datadir="D:/phpStudy2018/PHPTutorial/MySQL/data/"character-set-server=utf8defau...