First page Back Continue Last page Overview Graphics

Create Table / Insert (II)

sql_command = """

CREATE TABLE employee (

staff_number INTEGER PRIMARY KEY,

fname VARCHAR(20),

lname VARCHAR(30),

gender CHAR(1),

joining DATE,

birth_date DATE);"""

cursor.execute(sql_command)