mysql如何写注释

CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY COMMENT '员工ID',
    name VARCHAR(100) NOT NULL COMMENT '员工姓名',
    department_id INT COMMENT '部门ID',
    salary DECIMAL(10, 2) COMMENT '薪资'
) COMMENT='员工信息表';

# 示例 Python 脚本，用于在 SQL 文件中批量添加表注释
import re

def add_table_comments(sql_file):
    with open(sql_file, 'r') as file:
        sql_content = file.read()

    # 使用正则表达式查找 CREATE TABLE 语句
    pattern = r'CREATE TABLE (\w+) \('
    matches = re.findall(pattern, sql_content)

    for table_name in matches:
        comment = f' -- 表注释：{table_name} 的信息表'
        sql_content = sql_content.replace(f'CREATE TABLE {table_name} (', f'CREATE TABLE {table_name} {comment} (')

    with open(sql_file, 'w') as file:
        file.write(sql_content)

# 调用函数
add_table_comments('employees.sql')