android - SQLiteException 语法错误不清楚

Question

我明白了

android.database.sqlite.SQLiteException: near "WHERE": syntax error (code 1): , while compiling: insert or replace into taeglich (datum, a, b, c, d) 值('29.4 .2017', '10 ml f\n', '0.0', '0.0', '0.0') WHERE datum = '29.4.2017';

你看到语法错误了吗？

Answer 1

删除WHERE子句

insert or replace into taeglich VALUES ('29.4.2017', '10 ml f\n', '0.0', '0.0', '0.0');