Revision be68a428-3aaa-45a1-9c71-a07fd9c9c6b3 - Stack Overflow

I can't show the data from database sqlite in python.

 connection = sqlite3.connect('db')
 connection.cursor().execute('CREATE TABLE IF NOT EXISTS 'users' ( \
 id TEXT, \
 name TEXT, \
 avatar TEXT \
 )')

 # In cycle:
 query = 'INSERT INTO 'users' VALUES ("' + str(friend.id) + '", "' + friend.name + '", "' + friend.avatar +'" )'
 print query
 connection.cursor().execute(query)
 connection.commit()
 
 # After cycle
 print connection.cursor().fetchall()

Sample output of query variable:

 INSERT INTO users VALUES ("111", "Some Name", "http://avatar/path" )

In result, **fetchall** returns empty tuple. Why?

---------------
UPD
Forgotten code:

 connection.cursor().execute('SELECT * FROM users')
 connection.cursor().fetchall()
→
[]