Mikkel84
10/8/2018 - 7:25 AM

[query] #SQL #DB #Query #SQLite #Python

[query] #SQL #DB #Query #SQLite #Python

query.sql
content_copyfile_download
# SELECT <spaltenliste> FROM <tabellenname> [WHERE <bedingung>]
cursor.execute("SELECT fachnummer, komponente FROM lager WHERE reserviert=0 AND lieferant='FC'")
cursor.fetchall()  # shows requested data

# Query over all columns
cursor.execute("SELECT * FROM kunden")


# Queries across multiple tables = joins
cursor.execute("SELECT lager.fachnummer, lager.komponente, lieferanten.name FROM lager, lieferanten WHERE lieferanten.telefonnummer='011394567' AND lager.lieferant=lieferanten.kurzname")
cursor.fetchall()  # shows requested data



# return only 1 result of query (iteratively used here)
cursor.execute("SELECT * FROM kunden")
row = cursor.fetchone()
while row:
    print(row)
    row = cursor.fetchone()