mysql怎么删除注释

UPDATE your_table SET your_column = REPLACE(your_column, '#your_comment', '');

UPDATE your_table SET your_column = REPLACE(your_column, '-- your_comment', '');

UPDATE your_table SET your_column = REGEXP_REPLACE(your_column, '/\*.*?\*/', '');

import re

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

    # 删除单行注释
    sql_content = re.sub(r'--.*?$', '', sql_content, flags=re.MULTILINE)
    # 删除多行注释
    sql_content = re.sub(r'/\*.*?\*/', '', sql_content, flags=re.DOTALL)

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

# 使用示例
remove_comments('your_sql_file.sql')