1 year ago

#370032

test-img

Soul

My objective is to use user defined values in the sql query

 if result == datetime.datetime.now():
        print('book will be avilable today..')
        ask5 = input('Do you want to issue this book? yes/no: ')
        if ask5 == 'yes':
            issue()
            ask6 = input('enter your student id again for verification: ')
            subq = schooldb.execute('select student_id from issued_books where student_id = {}'.format(ask6))
            if subq[0] == ask6:
                pass

I keep on getting this as an error: raise errors.get_mysql_exception(exc.errno, msg=exc.msg, MySQL.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Cosmos' at line 1

python

mysql

mysql-connector

0 Answers

Your Answer

Accepted video resources