PEP 249 ( Im getting syntax error)
Vishal Gupta via DB-SIG <[email protected]> Mon, 22 Jun 2020 23:28:21 +0530
| Newsgroups | gmane.comp.python.db |
|---|---|
| Message-ID | <[email protected]> |
--===============8045548958791555486==
Content-Type: multipart/alternative;
boundary="Apple-Mail=_C7E24E1B-C49A-4243-9441-D6E52BAD2C64"
--Apple-Mail=_C7E24E1B-C49A-4243-9441-D6E52BAD2C64
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=us-ascii
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???
--Apple-Mail=_C7E24E1B-C49A-4243-9441-D6E52BAD2C64
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=us-ascii
<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3Dus-ascii"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;" class=3D""><div =
class=3D"">mydatatables.execute('''CREATE TABLES STUDENTS (</div><div =
class=3D"">studentID INTEGER PRIMARY AUTOINCREMENT KEY,</div><div =
class=3D"">CLASS INTEGER,</div><div class=3D"">SECTION TEXT (1) NOT =
NULL,</div><div class=3D"">ROLLNO INTEGER (2) NOT NULL,</div><div =
class=3D"">MARKS REAL NOT NULL,</div><div class=3D"">RANKING INTEGER (2) =
NOT NULL,</div><div class=3D"">INTEREST TEXT (10) ,</div><div =
class=3D"">SPORTS TEXT (10) NOT NULL,</div><div class=3D"">CODING =
BOOLEAN NOT NULL);''')</div><div class=3D"">mydatabase.close()</div><div =
class=3D""><br class=3D""></div><div class=3D""><br class=3D""></div><div =
class=3D"">SyntaxError: multiple statements found while compiling a =
single statement</div><div class=3D""><br class=3D""></div><div =
class=3D""><br class=3D""></div><div class=3D""><font color=3D"#ff4013" =
size=3D"4" class=3D"">May i request you to kindly tell what is the error =
in this code???</font></div></body></html>=
--Apple-Mail=_C7E24E1B-C49A-4243-9441-D6E52BAD2C64--
--===============8045548958791555486==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
DB-SIG maillist - [email protected]
https://mail.python.org/mailman/listinfo/db-sig
--===============8045548958791555486==--