Python Forum
error in python and mysql statement
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
error in python and mysql statement
#1
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s AND usertimeout IS NULL DESC LIMIT 1' at line 1

mysql = "SELECT usertimein FROM userstimeclock WHERE userid = %s AND usertimeout IS NULL DESC LIMIT 1"
            myparams = str( myresult2[0])
            mycursor.execute(mysql, myparams)
            myresult = mycursor.fetchone()
Reply


Messages In This Thread
error in python and mysql statement - by vj78 - Apr-07-2021, 10:15 PM
RE: error in python and mysql statement - by vj78 - Apr-07-2021, 10:31 PM
RE: error in python and mysql statement - by buran - Apr-08-2021, 05:26 AM
RE: error in python and mysql statement - by vj78 - Apr-08-2021, 01:29 PM
RE: error in python and mysql statement - by vj78 - Apr-08-2021, 02:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python and MYSQL Resultset vj78 2 797 Apr-02-2021, 12:41 AM
Last Post: vj78
  error when inserting list statement from python to MySQL ADBYITMS 0 764 Nov-10-2019, 10:44 AM
Last Post: ADBYITMS
  mysql database error brecht83 1 3,646 Dec-14-2018, 01:25 PM
Last Post: jeanMichelBain

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020