sqlite - 如何在sqlite中逃脱？

Question

我在下面的代码中使用反斜杠转义了两个分号。我正在 SQLite Database Brower 2.0 for Mac 中执行此代码。它一直在卡住。我猜这是因为一些语法问题？

INSERT INTO question (QuestionId, QuestionText, AreaId, AnswerText)
VALUES(6019, 'Math Functions', 6, "
Added: 9/1/2011

The following is a listing of math functions available:

Power of:
double pow ( double, double )
Example:
double myvar = pow(2,4)\;
NSLog(@"%.f", myvar)\; //value is 16");

Answer 1

分号不是你的问题，NSLog 中的双引号调用是:

NSLog(@"%.f", myvar)\; //value is 16"
       ^---^

将它们加倍，SQLite 会很高兴:

NSLog(@""%.f"", myvar)\; //value is 16"

或者你可以在整个事情周围使用单引号:

INSERT INTO question (QuestionId, QuestionText, AreaId, AnswerText)
VALUES(6019, 'Math Functions', 6, '
Added: 9/1/2011

The following is a listing of math functions available:

Power of:
double pow ( double, double )
Example:
double myvar = pow(2,4)\;
NSLog(@"%.f", myvar)\; //value is 16');

单引号是 SQL 字符串的标准，但 SQLite 允许您对字符串使用单引号或双引号。