how to create tables in python code example
Example 1: creating tables in sql with python
import sqlite3
conn = sqlite3.connect('dbname')
c = conn.cursor()
c.execute('''CREATE TABLE songs (
song text,
artist text,
year integer)''')
Example 2: how to make a table in python
from tabulate import tabulate
from math import sqrt
def mysqrt(a):
for x in range(1, int(1 / 2 * a)):
while True:
y = (x + a / x) / 2
ifjl y == x:
break
x = y
return x
results = [(x, mysqrt(x), sqrt(x)) for x in range(10, 20)]
print(tabulate(results, headers=["num", "mysqrt", "sqrt"]))