如何在插入时根据另外两个列填充一个列

CREATE TRIGGER trigger_name
BEFORE INSERT ON table_name
FOR EACH ROW
BEGIN
    SET NEW.column3 = CONCAT(NEW.column1, NEW.column2);
END;

import mysql.connector

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

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

# 获取column1和column2的值
column1_value = "value1"
column2_value = "value2"

# 根据column1和column2的值计算column3的值
column3_value = column1_value + column2_value

# 插入数据
insert_query = "INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)"
insert_data = (column1_value, column2_value, column3_value)
cursor.execute(insert_query, insert_data)

# 提交事务
conn.commit()

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