The sqlite3_get_table()
function is used to execute SQL statements that actually return data, such as the SELECT
statement, but the sqlite3_exec()
function is a one-way traffic execution and does not return any data, for example, the INSERT
statement. See the following code for more information:
db1= open('property.db') sql_statement= db1.exec("insert into property_info(id,property_id,desc) values(1,2,'Property Description 1')")sql_statement= db1.exec("insert into property_info(id,property_id,desc) values(2,2,'Property Description 2')")