从引用表中填充空值的最优雅方法

# 以Python为例
import mysql.connector

# 建立数据库连接
db_connection = mysql.connector.connect(
  host="localhost",
  user="username",
  password="password",
  database="database_name"
)

# 创建游标对象
cursor = db_connection.cursor()

# 检查空值并填充
def fill_null_values():
    query = "SELECT column_name FROM table_name WHERE column_name IS NULL"
    cursor.execute(query)
    null_columns = cursor.fetchall()
    
    for column in null_columns:
        query = f"SELECT value FROM reference_table WHERE column_name = '{column}'"
        cursor.execute(query)
        value = cursor.fetchone()
        
        if value:
            query = f"UPDATE table_name SET column_name = '{value[0]}' WHERE column_name IS NULL"
            cursor.execute(query)
        
    db_connection.commit()
    
# 调用函数进行填充
fill_null_values()

# 关闭连接
cursor.close()
db_connection.close()