how to create a table with 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"]))

Tags:

Sql Example