The idea
As a good tip to get the most of the table entries - you want the user to focus on their important data - but you don't want to overwhelm them with extra typing that can be done automatically by database system.Here is way to have an auto increment index and a default date and time of the entry done by the operator
Embedded during the table creation:
sqlite> create table testauto (autoid integer primary key autoincrement, autodate default (datetime('now')), notes text ) ;Operator just have to enter the notes column:
sqlite> insert into testauto (notes) values ('this is a test of the auto increment and default date' ) ;sqlite> insert into testauto (notes) values ('this is a second test of the auto increment and default date' ) ;
sqlite> insert into testauto (notes) values ('this is a third test of the auto increment and default date' ) ;
and as you see the index and the date are automatically filled
sqlite> select * from testauto ;1|2017年03月15日 15:34:05|this is a test of the auto increment and default date
2|2017年03月15日 15:34:14|this is a second test of the auto increment and default date
3|2017年03月15日 15:34:24|this is a third test of the auto increment and default date
sqlite>