MySQL批量轉換表名為小寫(Python指令碼)

feelpurple發表於2018-03-23
MySqlPython指令碼


  1. #!/usr/bin/env python
  2. # -*-encoding:utf8-*-
  3. #

  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()

  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)

  21. time.sleep(0.5)

  23. conn.close()
  24. db.close()


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26506993/viewspace-2152163/，如需轉載，請註明出處，否則將追究法律責任。

相關文章