![]() Difference between thread-safe and non-thread-safe.Difference between synchronous and asynchronous ca.Difference between Strong and Weak in iOS.What are join in sql? Explain Types of Join.Difference between viewdidload and viewwillappear?.It should be called after having finished any data exchange with the database, as it releases any reserved system resources. Sqlite3_close: It closes an open database connection. Sqlite3_finalize: It deletes a prepared statement from memory. Sqlite3_errmsg: It returns the description of a SQLite error. Sqlite3_last_insert_rowid: It returns the last inserted row’s ID. Sqlite3_changes: It actually returns the number of the affected rows, after the execution of a query. Sqlite3_column_name: It returns the name of a column, and its parameters are the same to the previous function’s. It accepts two parameters: The first one is the query converted (compiled) to a SQLite statement, and the second one is the index of the column. Sqlite3_column_text: This method returns the contents of a column in text format, actually a C string (char *) value. It returns the total number of columns (fields) a contained in a table. Sqlite3_column_count: This method’s name it makes it easy to understand what is about. It’s important to have in mind that it can’t be called prior to the sqlite3_preprare_v2 function. It can be called just once for executable queries (insert, update, delete), or multiple times when retrieving data. Sqlite3_step: This function actually executes a SQL statement (query) prepared with the previous function. Sqlite3_prepare_v2: The purpose of this function is to get a SQL statement (a query) in string format, and convert it to an executable format recognisable by SQLite3. If the file does not exist, then it creates it first and then it opens it, otherwise it just opens it. It accepts two parameters, where the first one is the database file name, and the second a handler to the database. Sqlite3_open: This function is used to create and open a database file. SELECT * FROM table WHERE ID = SELECT LAST_INSERT_ROWID() Sqlite : SELECT * FROM table ORDER BY column DESC LIMIT 1 ![]() If column is primary key and integer, then ,
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |