2
2
20two.may2020-10-18 16:00:15
SQLite
20two.may, 2020-10-18 16:00:15

Why is the SQLite3 entry not being deleted?

You need to remove the clan_id entry.

cursor.execute("DELETE clan_id FROM clans WHERE owner_id = {}".format(ctx.author.id))

Error: sqlite3.OperationalError: near "clan_id": syntax error

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander, 2020-10-18
@20two_may

writing queries without understanding them is a bad choice.
https://www.w3schools.com/sql/sql_delete.asp

D
Dr. Bacon, 2020-10-18
@bacon

The reason is clearly indicated in the error, why is clan_id there?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question