Sqlite3_column_count always returns 1

Question

sqlite3_stmt *statement; selectSql = "SELECT title FROM list"; sqlite3_prepare_v2(database, selectSql, -1, &statement, NULL); countColumn = sqlite3_column_count(statement); NSLog(@"%d",countColumn); 

why this account always returns 1
In fact, the table has 18 entries

Answer 1

This is because your statement only select single column ( title ). Try this and see what it returns:

 sqlite3_stmt *statement; selectSql = "SELECT * FROM list"; sqlite3_prepare_v2(database, selectSql, -1, &statement, NULL); countColumn = sqlite3_column_count(statement); NSLog(@"%d",countColumn); 

Answer 2

Do you mean a row, not a column, an account? The number of columns (in the name of your case) is really always 1.