Code: Alles auswählen
def getMaxAlter(self, table):
sql = 'SELECT max(Alter) from ?'
try:
self.cur.execute(sql,(table,))
except sqlite3.OperationalError as e:
print("SQL Fehler: ", e.args)
Code: Alles auswählen
def getMaxAlter(self, table):
sql = 'SELECT max(Alter) from ?'
try:
self.cur.execute(sql,(table,))
except sqlite3.OperationalError as e:
print("SQL Fehler: ", e.args)
Code: Alles auswählen
In [16]: cur.execute('create table person (id integer primary key, age integer)')
Out[16]: <sqlite3.Cursor at 0x9861720>
In [17]: con.commit()
In [18]: cur.execute('select max(age) from person')
Out[18]: <sqlite3.Cursor at 0x9861720>
In [19]: cur.fetchone()
Out[19]: (None,)