<code>import sqlite3
def request():
with sqlite3.connect('sqlite_db.db') as sqlite_conn:
sql_request = 'SELECT t,80 FROM SS_SZT'
sql_cursor = sqlite_conn.execute(sql_request)
res = sql_cursor.fetchall()
for i in res:
print(i)
request()
</code>
<code>import sqlite3
def request():
with sqlite3.connect('sqlite_db.db') as sqlite_conn:
sql_request = 'SELECT t,80 FROM SS_SZT'
sql_cursor = sqlite_conn.execute(sql_request)
res = sql_cursor.fetchall()
for i in res:
print(i)
request()
</code>
import sqlite3
def request():
with sqlite3.connect('sqlite_db.db') as sqlite_conn:
sql_request = 'SELECT t,80 FROM SS_SZT'
sql_cursor = sqlite_conn.execute(sql_request)
res = sql_cursor.fetchall()
for i in res:
print(i)
request()
output:
(12.0, 80)
(8.0, 80)
(4.0, 80)
(2.0, 80)
(1.0, 80)
(0.5, 80)
enter image description here
It outputs the value of column t. I just don’t understand why it can’t output the value of a column with numbers (although they are essentially the same type as the column t, i.e. string)
New contributor
Jabbatron is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.