Question

如何在SQLite数据库表中删除行

Answer 1

本节视频我们来聊一聊如何删除数据表的行。Treelab 官网（免费注册体验）：www.treelab.com.cn

Answer 2

countSQL=[NSString stringWithFormat:@" DELETE FROM Contacts WHERE ID='%@\'",[dic objectForKey:@"ID"]];
if (sqlite3_exec (database, [countSQL UTF8String], NULL, NULL, &erroMsg) != SQLITE_OK)
{
NSAssert1(0, @"Error updating tables: %s", erroMsg);
}