objective-c - iOS FMDatabase插入时 返回YES 但是就是插不进数据库 这是为什么

Question

result = [_db executeUpdate:@"INSERT INTO CommentNotice (is_read,comment_id) VALUES (?,?)",temp[@"is_read"],temp[@"comment_id"]];

result返回YES 但是我去本地数据库看 结果没插进去这是为什么

Answer 1

Where is the db stored?

Answer 2

1. Check whether your sqlite file is under Document

2. Have you opened the transaction and not committed

Answer 3

Copy the db from the application and take a look,

Print the value before inserting.

It’s best to test it with sql tool before writing