Dec-18-2022, 05:44 PM
Hi everyone,
I have an INNER JOIN command in my python
for exemple
I have try few thing
but that always return -1 even if I have a result.
also
I have an INNER JOIN command in my python
for exemple
cursor.execute(''' SELECT a1, a2, b1, b2 FROM A INNER JOIN B on B.f = A.f; ''')OK now let suppose that the result is nothing. How can I know ?
I have try few thing
cursor.rowcount
but that always return -1 even if I have a result.
also
test = cursor.execute(''' SELECT a1, a2, b1, b2 FROM A INNER JOIN B on B.f = A.f; ''') type(test)
Output:<class 'sqlite3.Cursor'>
Any ideas ?