产生的原因：android.database.sqlite.SQLiteException：没有这样的柱：L

Question

Caused by: android.database.sqlite.SQLiteException: no such column: kia (code 1): , while compiling: UPDATE people_chat SET msg = kia WHERE name = uol 

final String CREATE_QUERY4 = "CREATE TABLE IF NOT EXISTS "+PEOPLE_CHAT+ "("+ "id INTEGER primary key autoincrement,"+ "name TEXT NOT NULL ,"+ "msg TEXT NOT NULL "+ ")"; 

列表项

public void upDateMsg(String name,String msg){ 
     Log.i(TAG, "UpdateData: "+msg); 
     String strSQL = "UPDATE people_chat SET msg = "+msg+" WHERE name = "+ name; 
     db.execSQL(strSQL); 
     Log.i(TAG, "Update Success: "+strSQL); 
    } 
} 

Answer 1

它应该是：

UPDATE people_chat SET msg = 'kia' WHERE name = 'uol' 

你缺少单引号。更改代码：

String strSQL = "UPDATE people_chat SET msg = '"+msg+"' WHERE name = '"+ name+"'"; 

注：正如指出的意见，如果名称中包含单引号，则查询会失败。它必须相应地逃脱。