> Create a single table with field id int ... Alter the table and add a column to it which is not null As a rule, you're much more likely to get useful responses if you'll post your SQL instead of expecting all potential responders to come up with their own variation of it. Likewise, a copy/paste of the sqlite3 CLI session is always more useful than a summary of what sqlite3 said.