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=3306 basedir="D:/phpStudy2018/PHPTutorial/MySQL/" datadir="D:/phpStudy2018/PHPTutorial/MySQL/data/" character-set-server=utf8 defau...