On Sat, 16 Feb 2008 11:29:29 +1100, BareFeet <[EMAIL PROTECTED]> wrote: > If you designate an integer column as also being the primary key, > then SQLite will auto assign its value incrementally each time > you insert a new row, unless you assign a value explicitly.
In this case, why do we need to use "PRIMARY KEY AUTOINCREMENT"? Shouldn't "PRIMARY KEY" be enough to have SQLite auto-increment this column if it's NULL? >I wouldn't expect any problems using dates in the YYYY-MM-DD format. >But Julian (real) format is the preferred method and uses less memory >(less bytes) and I suspect is quicker to process. Thanks for the tip. >either by creating a view in SQLite (and having PHP reference it) or >else using directly from PHP. I've never used views in SQLite. I'll take a look at what they do and if they offer a better solution. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
