How to provide user id in mysql using Python [duplicate]

Question

I want to search for a user in a table by the user id from discord, but I can't provide the id in mysql. I get an error You have an error in your SQL syntax; But I don't understand what's wrong.

    @commands.command()
    async def balance(self, ctx):
        create_balance(ctx)
        query = ("SELECT UserID FROM userdata "
                 "WHERE UserID = %s")

        user_id = ctx.message.author.id
        cur.execute(query, (user_id))
        for (UserID, score) in cur:
            print(UserID,score)

Your select query should include the "score" field. In this way: SELECT UserID,score FROM userdata — Arash
– Arash, Commented Jul 28, 2021 at 19:22

nbk · Accepted Answer · 2021-07-28 19:20:40Z

3

in python in conjunction with mysql connector a tuple needs at least 2 dimensions

so make

cur.execute(query, (user_id,))

answered Jul 28, 2021 at 19:20

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

How to provide user id in mysql using Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related