PaintingliteShortcutSQL
IntroductionPaintingliteShortcutSQL 提供SDK框架中部分操作宏定义 Functions
ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN)修改表 #define ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN) [NSString stringWithFormat:@"ALTER TABLE %@ ADD COLUMN %@",NEW_TABLE_NAME,ADD_COLUMN] Discussion修改表[列] See Also ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME)修改表 #define ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME) [NSString stringWithFormat:@"ALTER TABLE %@ RENAME TO %@",OLD_TABLE_NAME,NEW_TABLE_NAME] Discussion修改表[名称] See Also CREATE_TBALE(TABLE_NAME,TABLE_CONTENT)创建表 #define CREATE_TBALE(TABLE_NAME,TABLE_CONTENT) [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(%@)",TABLE_NAME,TABLE_CONTENT] Discussion创建表 See Also DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE)删除操作 #define DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE) [NSString stringWithFormat:@"DELETE FROM %@ WHERE %@",TABLE_NAME,TABLE_DELETE_WHERE] Discussion删除操作 See Also DROP_TABLE(TABLE_NAME)删除表 #define DROP_TABLE(TABLE_NAME) [NSString stringWithFormat:@"DROP TABLE %@",TABLE_NAME] Discussion删除表 See Also INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT)插入操作 #define INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT) [NSString stringWithFormat:@"INSERT INTO %@(%@) VALUES %@",TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT] Discussion插入操作 See Also UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE)更新操作 #define UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE) [NSString stringWithFormat:@"UPDATE %@ SET %@ WHERE %@",TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE] Discussion更新操作 See Also Macro Definitions
ALTER_TABLE_ADD_COLUMN修改表 #define ALTER_TABLE_ADD_COLUMN(NEW_TABLE_NAME,ADD_COLUMN) [NSString stringWithFormat:@"ALTER TABLE %@ ADD COLUMN %@",NEW_TABLE_NAME,ADD_COLUMN] Discussion修改表[列] See Also ALTER_TABLE_NAME修改表 #define ALTER_TABLE_NAME(OLD_TABLE_NAME,NEW_TABLE_NAME) [NSString stringWithFormat:@"ALTER TABLE %@ RENAME TO %@",OLD_TABLE_NAME,NEW_TABLE_NAME] Discussion修改表[名称] See Also COMMIT提交 Discussion提交 CREATE_TBALE创建表 #define CREATE_TBALE(TABLE_NAME,TABLE_CONTENT) [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(%@)",TABLE_NAME,TABLE_CONTENT] Discussion创建表 See Also DELETE_TABLE删除操作 #define DELETE_TABLE(TABLE_NAME,TABLE_DELETE_WHERE) [NSString stringWithFormat:@"DELETE FROM %@ WHERE %@",TABLE_NAME,TABLE_DELETE_WHERE] Discussion删除操作 See Also DROP_TABLE删除表 #define DROP_TABLE(TABLE_NAME) [NSString stringWithFormat:@"DROP TABLE %@",TABLE_NAME] Discussion删除表 See Also INSERT_TABLE插入操作 #define INSERT_TABLE(TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT) [NSString stringWithFormat:@"INSERT INTO %@(%@) VALUES %@",TABLE_NAME,TABLE_COLUMN,TABLE_INSERT_CONTENT] Discussion插入操作 See Also ROLLBACK回滚 Discussion回滚 TRANSACTION开启事务 #define TRANSACTION @"BEGAIN" Discussion开启事务 UPDATE_TABLE更新操作 #define UPDATE_TABLE(TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE) [NSString stringWithFormat:@"UPDATE %@ SET %@ WHERE %@",TABLE_NAME,TABLE_UPDATE_SET,TABLE_UPDATE_WHERE] Discussion更新操作 See Also |