Fehler beim Speichern eines Wörterbuchs in MySQL -Tabelle vor Python -Code in MySQL -Tabelle ⇐ Python

[Anonymous]

Ich versuche, ein Diktat in die MySQL -Tabelle zu speichern, deren Schlüssel Spalten und Werte sind Zeilen. Dieses Diktat hat Schlüssel, die eine Teilmenge aller Spalten einer Tabelle sind. Ich verwende den folgenden Code in Python < /p>
sql_dict = {'deviceID': 'fd00::212:4b00d1b1', 'date': '2020-02-22', 'timestamp': '18:39:29.620329', 'counter': 72, 'rssi': 59, 'CH_1_Leavinng_Chiller_Liq_Temp': 7.7, 'CH_1_Motor_Current_limit_SP': 7.8, 'CH_1_Leaving_Condensor_liq_temp': 36.1, 'CH_1_Motor_Current_Percentage': 9.9, 'CH_1_Discharge_temp': 45.1, 'CH_1_Oil_Sump_temp': 45.6, 'CH_1_Remote_start_stop': 0.0, 'CH_1_Variable_speed_type': 0.0, 'Bypass line temp sensor ': -1274.8}
< /code>
sql_insert_query = """ INSERT INTO Data {} VALUES {}""".format(tuple(sql_dict.keys()), tuple(sql_dict.values()))
< /code>
I get an error when I run my code

Failed inserting record into python_users table 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''deviceID', 'date', 'timestamp', 'counter', 'rssi', 'CH_1_Leavinng_Chiller_Liq_T'

Where am I going wrong?
My table desc for reference: