Python自动化之批量修改数据库字符集

最新推荐文章于 2022-12-17 12:54:52 发布

Micky_Yang

最新推荐文章于 2022-12-17 12:54:52 发布

阅读量371

点赞数

分类专栏： Python学习笔记

本文链接：https://blog.csdn.net/Micky_Yang/article/details/105855203

版权

Python学习笔记专栏收录该内容

7 篇文章 0 订阅

订阅专栏

# Author:JiangYiyang
import pymysql
conn = pymysql.connect(
    host='localhost',
    port=3306,
    user='confluenct',
    password='jyy',
    db='confluence',
    use_unicode=True,
    cursorclass=pymysql.cursors.DictCursor)
cursor = conn.cursor()
conn.autocommit(True)
cursor.execute('show tables;')
data = cursor.fetchall()
for item in data:
    table_name=item['Tables_in_confluence']
    cursor.execute(
        'alter table %s convert to character set utf8mb4 collate utf8mb4_bin;'%(table_name)
    )
cursor.execute('show create table users;')
data2 = cursor.fetchall()
print(data2)
cursor.close()
conn.close()