Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.execute("CREATE TABLE tLPs (LP VARCHAR(20), Dir VARCHAR(255), Mercosur TINYINT, H0 TINYINT, H1 TINYINT, H2 TINYINT, H3 TINYINT, H4 TINYINT, H5 TINYINT, H6 TINYINT, H7 TINYINT, H8 TINYINT, keyid INT AUTO_INCREMENT, UNIQUE KEY(LP), PRIMARY KEY(keyid))");
- sqlite3.OperationalError: near "KEY": syntax error
- db.execute("CREATE TABLE tLPs (LP VARCHAR(20), Dir VARCHAR(255), Mercosur TINYINT, H0 TINYINT, H1 TINYINT, H2 TINYINT, H3 TINYINT, H4 TINYINT, H5 TINYINT, H6 TINYINT, H7 TINYINT, H8 TINYINT, keyid INT AUTO_INCREMENT, PRIMARY KEY(keyid))");
Add Comment
Please, Sign In to add comment