create sql tables python code example

Example: 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)''')