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

Dieter Maurer dieter at handshake.de
Wed Jun 24 12:24:23 EDT 2020


Vishal Gupta wrote at 2020-6-22 23:28 +0530:
>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

While I do not see multiple statements, a see
a "CREATE TABLES" which almost surely should by "CREATE TABLE" (without "S"
suffix).


More information about the DB-SIG mailing list