# 查询表是否存在 cursor.execute("SHOW TABLES LIKE 'k8s_memory_7d_use'") result = cursor.fetchone()
# 如果表不存在,则创建表 ifnot result: cursor.execute(""" CREATE TABLE k8s_memory_7d_use ( id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, k8s_cluster VARCHAR(50) NOT NULL, namespace VARCHAR(50) NOT NULL, pod VARCHAR(50) NOT NULL, instance VARCHAR(50) NOT NULL, memory_7d_arrive_now_max_unit_M INT(11) NOT NULL, Memory_Limit_M INT(11) NOT NULL, Memory_Use_percentage FLOAT(6,2) NOT NULL ) """) print("Table k8s_memory_7d_use created successfully")