sqlite python insert with where condition

Question

from this post http://stackoverflow.com/questions/2130641/sqlite-python-insert I learned inserting into tables but now I need to use where something like

cursor.execute("insert into table1(id) values (?) where ip=? and address=?",(id,),(ip,),(addr,));

Answer 1

INSERT does not have a WHERE clause. I think you mean UPDATE.

Answer 2

You can't use a WHERE clause in an INSERT. If you want to specify the values for particular fields to insert, put them in the values clause:

cursor.execute("INSERT INTO table1(id, ip, address) VALUES (?, ?, ?)", (id, ip, addr))