在可能包含NULL的列上加入

import mysql.connector

# 连接腾讯云数据库
mydb = mysql.connector.connect(
    host="your_database_host",
    user="your_database_user",
    password="your_database_password",
    database="your_database_name"
)

# 创建一个唯一ID列
sql = "CREATE TABLE your_table_name (unique_id INT AUTO_INCREMENT PRIMARY KEY, column1 VARCHAR(255), column2 VARCHAR(255))"
mydb.execute(sql)

# 将可能包含NULL的列的值替换为唯一ID列的值
sql = "SELECT COALESCE(your_column_name, (SELECT unique_id FROM your_table_name ORDER BY RAND() LIMIT 1)) FROM your_table_name"
result = mydb.execute(sql)

# 打印结果
for row in result:
    print(row)