delete rows with different dates in mysql using python

Question

I have a MySQL table in which every row contains a 'Date' value. I want to delete all the rows where the date is unequal to the current date. I tried using the following lines to do so:

date = time.strftime('%Y-%m-%d')

mycursor.execute("DELETE FROM " + League + " WHERE Date != " + "'" + date + "'")

It runs fine, but it doesn't actually delete any rows, even though I am sure there are rows with different dates. How can I delete these rows?

sql not equal is <> if I am not wrong, also you need to commit the transaction, also don't use string concatenation, it is prone to SQL injection — Epsi95
– Epsi95, Commented Aug 23, 2021 at 15:28
@Epsi95 Simply adding a commit statement worked. Thank you! How would you get rid of the concatenation? I have this right now: ` mycursor.execute("DELETE FROM %s WHERE Date <> %s", (League, Date)) ` But it gives a syntax error. — AxelotlZ
– AxelotlZ, Commented Aug 24, 2021 at 12:05

ujjaldey · Accepted Answer · 2021-08-23 16:58:54Z

1

your code seems to be fine. What is League? Hope it's a variable for your table name! Also, use bind variables and avoid using string concatenations.

date = time.strftime('%Y-%m-%d')
print(date)

conn = database.create_db_connection()
cursor = conn.cursor()

query = "DELETE FROM test WHERE date != %s"
cursor.execute(query, date)
conn.commit()

edited Aug 23, 2021 at 16:58

answered Aug 23, 2021 at 16:45

ujjaldey

4392 gold badges6 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

delete rows with different dates in mysql using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related