$sql = 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="new"';
$tables =$this->model->query($sql);
$alter_sql = '';
foreach ($tables as $t){
$new_name = preg_replace('#^old#','new',$t['TABLE_NAME']);
strcmp($new_name,$t['TABLE_NAME']) && $alter_sql .='ALTER TABLE'.$t['TABLE_NAME'].'RENAME TO '.$new_name.';<br>';
}
转载于:https://blog.51cto.com/phpervip/1876863