matty-cakes
/ planet-express-co-sqlite3-basics-tutorial.py
Created
June 2, 2023 23:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import sqlite3 | |
| def create_employee_table(cursor): | |
| stmt = """ | |
| CREATE TABLE IF NOT EXISTS employee( | |
| id INTEGER PRIMARY KEY, | |
| first_name TEXT, | |
| last_name TEXT, | |
| email TEXT UNIQUE NOT NULL, |