MySQL批量转换表名为小写(Python脚本)

1. #!/usr/bin/env python
   
2. # -*-encoding:utf8-*-
   
3. #
   
4. 
   
5. import MySQLdb
   
6. import time
   
7. step = 0
   
8. db = MySQLdb.connect(host = '192.168.20.42',port = 61306,user = 'test',passwd = 'test' , db = 'information_schema')
   
9. conn = db.cursor()
   
10. 
    
11. sql = '''select TABLE_SCHEMA, table_name from information_schema.tables where table_schema not in ('information_schema', 'performance_schema', 'mysql') '''
    
12. # print sql
    
13. conn.execute(sql)
    
14. if conn.rowcount > 0:
    
15.         for item in conn.fetchall():
    
16.                 sql = '''rename table %s.%s to %s.%s''' % (item[0], item[1], item[0], item[1].lower())
    
17.                 if item[1].isupper():
    
18.                         print sql
    
19.                         conn.execute(sql)
    
20. 
    
21. time.sleep(0.5)
    
22. 
    
23. conn.close()
    
24. db.close()

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2152163/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2152163/