1 year ago
#370032
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