Python · Theory

Create tables

← All stacks

Theory

114/268

Create tables

Create tables is a Python idea you use in small programs. Learn it with one example, not a long speech.

Learn Create tables with one small script. Change one value and guess the new print.

Create tables — output — table student created. Same CREATE TABLE on MySQL.

Exam tip

Run this Create tables example and say the output.

Example

# Create tables
import sqlite3
con = sqlite3.connect(":memory:")
con.execute("create table student(id integer, name text)")
print("table student created")
con.close()

Create tables — output: table student created. Same CREATE TABLE on MySQL.

Short notes

DefCreate tables — one clear use.
RuleTiny script + printed result.
TrapName only, no example.

Python · Theory

Create tables

← All stacks

Theory

114/268

Create tables

Create tables is a Python idea you use in small programs. Learn it with one example, not a long speech.

Learn Create tables with one small script. Change one value and guess the new print.

Create tables — output — table student created. Same CREATE TABLE on MySQL.

Exam tip

Run this Create tables example and say the output.

Example

# Create tables
import sqlite3
con = sqlite3.connect(":memory:")
con.execute("create table student(id integer, name text)")
print("table student created")
con.close()

Create tables — output: table student created. Same CREATE TABLE on MySQL.

Short notes

DefCreate tables — one clear use.
RuleTiny script + printed result.
TrapName only, no example.

Create tables

Example

Short notes

Questions

Create tables

Example

Short notes

Questions