- mysql -uroot -p123456 -e "use information_schema;select concat('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE = InnoDB;') from TABLES where TABLE_SCHEMA like 'xxxdb_%' and ENGINE != 'InnoDB';"
 
1040阅读 0评论2013-05-04 zhengsenlin888
    分类:LINUX