Question

How should a correct INSERT WHERE statement look like? I have a normal INSERT statement which looks like this and it works:

tx.executeSql("INSERT INTO Vocables (english, german) VALUES (?, ?)", new Object[]{eng, ger}, new StatementCallback<JavaScriptObject>()

But how should look like an INSERT WHERE statement? I tried this but it doesn t work.

("INSERT INTO Vocables (english, german) VALUES (?, ?) WHERE id=(?)", new Object[]{eng, ger,id});

我收到这一错误信息:

could not prepare statement(1 near "WHERE": syntax error)

Answer 1

页: 1 WHERE /code> 指令......

如何看待正确的INSERT WHERE声明?

不含<条码>。

Answer 2

insert into Vocables 
    select column1, column2 from other_table where ...