我有以下execSQL，它引发语法错误并导致我的应用程序崩溃。考虑到我已经忽略了单引号和双引号，我不知道为什么。
这是代码：
database.execSQL("insert into " + TABLE_EXERCISES + " (" + COLUMN_NAME + ", " + COLUMN_PRIMARY_MUSCLE + ", " + COLUMN_SECONDARY_MUSCLE + ", " + COLUMN_EQUIPMENT_TYPE + ", " + COLUMN_STEPS + ", " + COLUMN_IMAGES + ") values ('Cable Shrugs', 'Traps', 'None', 'Cable', 'Attach a flat shoulder width bar to the lowest cable pulley. Stand with your feet shoulder width apart. Keep your abs tight and a slight bend in your knees to protect your lower back. Starting with the bar at waist height, raise your shoulders toward your ears as if you\'re saying,\"I don\'t know.\" Hold briefly at the top of the contraction then lower in a slow and controlled manner.', 'cable-shrugs-1.png|cable-shrugs-2.png')");
有人知道吗
这是日志：
12-29 23:31:54.174: E/AndroidRuntime(1207): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.gauvion.gfit/com.gauvion.gfit.RoutinesActivity}: android.database.sqlite.SQLiteException: near "re": syntax error (code 1): , while compiling: insert into exercises(name, primary_muscle, secondary_muscle, equipment_type, steps, images) VALUES ('Cable Shrugs', 'Traps', 'None', 'Cable', 'Attach a flat shoulder width bar to the lowest cable pulley. Stand with your feet shoulder width apart. Keep your abs tight and a slight bend in your knees to protect your lower back. Starting with the bar at waist height, raise your shoulders toward your ears as if you're saying,"I don't know." Hold briefly at the top of the contraction then lower in a slow and controlled manner.', 'cable-shrugs-1.png|cable-shrugs-2.png')
最佳答案
你是
有你的错误。您没有逃脱撇号。据我所知，如果您使用''，这将起作用。
注意：对于“使用”和“使用”
尝试这个：
database.execSQL（“插入到” + TABLE_EXERCISES +“（” + COLUMN_NAME
+“，” + COLUMN_PRIMARY_MUSCLE +“，” + COLUMN_SECONDARY_MUSCLE +“，” + COLUMN_EQUIPMENT_TYPE +“，” + COLUMN_STEPS +“，” + COLUMN_IMAGES +“）值（“电缆耸肩”，“陷阱”，“无”，“ C” '，'附上公寓
最低的电缆滑轮的肩宽杆。用脚站立
肩宽分开。保持腹肌紧绷并稍微弯曲
膝盖保护您的下背部。从腰部的杠铃开始
高度，将您的肩膀抬高朝向耳朵，好像您在说，“”我
不知道。“”紧握住收缩的顶部，然后降低
以缓慢而受控的方式。”，
'cable-shrugs-1.png | cable-shrugs-2.png'）“）;
关于android - execSQL导致语法错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/14086948/