python - 如何使用 python 和 mysql 删除表的内容

Question

大家好，我想在输入新数据之前删除我的表格的内容，但我似乎无法让它工作，我不断收到错误，或者有更好的方法，然后我正在尝试这样做，这里是代码提前感谢大家的帮助

import mysql.connector
import pandas as pd
import mysql.connector
from mysql.connector import Error



print ("Clearning Flight Data table for new data")


try:
    connection = mysql.connector.connect(host='localhost',
                                         database='flightdata',
                                         user='root',
                                         password='*****')
    cursor = connection.cursor()
    Delete_all_rows = """flightinfo """
    cursor.execute(Delete_all_rows)
    connection.commit()
    print("All Record Deleted successfully ")

except mysql.connector.Error as error:
    print("Failed to Delete all records from database table: {}".format(error))
finally:
    if (connection.is_connected()):
        cursor.close()
        connection.close()
        print("MySQL connection is closed")


print ("Running Sydney KWS Domestic update")
import syd_kws_dom


print ("Running Sydney KWS International update")
import syd_kws_int

标签： pythonmysql

Answer 1

• 您可以delete使用cursor.execute.

Delete_all_rows = """delete from flightinfo """
cursor.execute(Delete_all_rows)