[DB-SIG] PEP 249 ( Im getting syntax error)

Vishal Gupta vishalgupta1973 at icloud.com
Mon Jun 22 13:58:21 EDT 2020


mydatatables.execute('''CREATE TABLES STUDENTS (
studentID INTEGER PRIMARY AUTOINCREMENT KEY,
CLASS INTEGER,
SECTION TEXT (1) NOT NULL,
ROLLNO INTEGER (2) NOT NULL,
MARKS REAL NOT NULL,
RANKING INTEGER (2) NOT NULL,
INTEREST TEXT (10) ,
SPORTS TEXT (10) NOT NULL,
CODING BOOLEAN NOT NULL);''')
mydatabase.close()


SyntaxError: multiple statements found while compiling a single statement


May i request you to kindly tell what is the error in this code???
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20200622/7f467391/attachment.html>


More information about the DB-SIG mailing list