agw Posted July 19, 2020 Share Posted July 19, 2020 I am trying to make calls from python to a MySQL database using variables but the placeholder %s is not working. Here is my code: mycursor = connection.cursor() sql = "SELECT * FROM Users WHERE username = %s" val = ("Agwebberley") mycursor.execute(sql, val) myresult = mycursor.fetchall() print(myresult) Quote Link to comment Share on other sites More sharing options...
Krydos Posted July 20, 2020 Share Posted July 20, 2020 Which version of python are you using? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.