Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Creating the columns
- Played = fList[0][0]
- Team = fList[0][1]
- GP = fList[0][2]
- W = fList[0][3]
- D = fList[0][4]
- L = fList[0][5]
- F = fList[0][6]
- A = fList[0][7]
- GD = fList[0][8]
- Pts = fList[0][9]
- queryCreateTable = """CREATE TABLE FOOTBALL(
- {} int(2) not null,
- {} varchar(255) not null,
- {} int(2) not null,
- {} int(2) not null,
- {} int(2) not null,
- {} int(2) not null,
- {} int(2) not null,
- {} int(2) not null,
- {} int(3) not null,
- {} int(3) not null
- )""".format(Played, Team, GP, W, D, L, F, A, GD, Pts)
- cursor.execute(queryCreateTable)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement