将时间戳与其他变量一起插入mariaDB表

CREATE TABLE my_table (
  id INT AUTO_INCREMENT PRIMARY KEY,
  timestamp TIMESTAMP,
  variable1 VARCHAR(255),
  variable2 INT
);

import mysql.connector
from datetime import datetime

# 获取当前时间戳和其他变量的值
timestamp = datetime.now()
variable1 = "value1"
variable2 = 123

# 连接到MariaDB数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 构造插入语句
insert_stmt = "INSERT INTO my_table (timestamp, variable1, variable2) VALUES (%s, %s, %s)"
data = (timestamp, variable1, variable2)

# 执行插入语句
cursor.execute(insert_stmt, data)

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()