如何将复杂的linux终端命令输出插入到mysql数据库表中

CREATE DATABASE command_output;
USE command_output;
CREATE TABLE output (
    id INT AUTO_INCREMENT PRIMARY KEY,
    command VARCHAR(255),
    output TEXT,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

import subprocess
import mysql.connector

# 运行Linux终端命令
command = "your_complex_linux_command"
output = subprocess.check_output(command, shell=True).decode("utf-8").strip()

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

# 插入命令输出到数据库表
insert_query = "INSERT INTO output (command, output) VALUES (%s, %s)"
data = (command, output)
cursor.execute(insert_query, data)

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()