mysql 字段添加注释

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL COMMENT '用户姓名',
    email VARCHAR(255) NOT NULL UNIQUE COMMENT '用户邮箱'
);

ALTER TABLE example_table MODIFY COLUMN email VARCHAR(255) NOT NULL UNIQUE COMMENT '用户电子邮箱地址';

SHOW CREATE TABLE example_table;

SHOW FULL COLUMNS FROM example_table;

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database'
}

cnx = mysql.connector.connect(**config)
cursor = cnx.cursor()

# 批量修改注释的 SQL 语句
update_statements = [
    "ALTER TABLE example_table MODIFY COLUMN name VARCHAR(255) NOT NULL COMMENT '用户姓名'",
    "ALTER TABLE example_table MODIFY COLUMN email VARCHAR(255) NOT NULL UNIQUE COMMENT '用户电子邮箱地址'"
]

for statement in update_statements:
    cursor.execute(statement)

cnx.commit()
cursor.close()
cnx.close()