连接mysql数据库格式化

import mysql.connector

try:
    conn = mysql.connector.connect(user='username', password='password', host='localhost', database='dbname')
    cursor = conn.cursor()
    sql = "SELECT * FROM table_name WHERE column = %s"
    cursor.execute(sql, ('value',))
    result = cursor.fetchall()
    for row in result:
        print(row)
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    conn.close()

import mysql.connector

try:
    conn = mysql.connector.connect(user='username', password='password', host='localhost', database='dbname')
    cursor = conn.cursor()
    data = {'column1': 'value1', 'column2': 123}
    sql = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
    cursor.execute(sql, (data['column1'], data['column2']))
    conn.commit()
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    conn.close()