SQLiteException:近";“语法错误(代码1)：，编译时:插入到SubjectsDB(‘软技能’，‘否’)；

Question

boolean DBExist = checkDatabaseExist();
Toast.makeText(this,DBExist + " <- DB Exists :p",Toast.LENGTH_LONG).show();
if(!DBExist){
SQLiteDatabase DB = openOrCreateDatabase(DB_NAME, MODE_PRIVATE, null);
try{
    DB.execSQL("CREATE TABLE IF NOT EXISTS SubjectsDB(name VARCHAR, major VARCHAR);");
    DB.execSQL("INSERT INTO SubjectsDB(\'softskill\',\'no\');");
}catch (Exception e){
    Toast.makeText(this,"Ohh!!"+e.toString(),Toast.LENGTH_LONG).show();
}
Toast.makeText(this,"Data Entered Successfully",Toast.LENGTH_LONG).show();

这是我试图将这两个字符串插入数据库的代码，但在分号处会出现错误。

Answer 1

使用以下代码

DB.execSQL("INSERT INTO SubjectsDB values(\'softskill\',\'no\');");