On 21/08/2009 12:59 PM, Simon Slavin wrote: > On 21 Aug 2009, at 3:26am, pierr wrote: > >> I did not know the sequence in defining the field matters. This is >> what I should have done. > > Sorry, I should have explained better. You were right: there is no > difference. I was just rearranging the fields in the classic way: > with the primary key column as the first column. It helps me think > about how the database works. You did nothing wrong.
Pierr had "INT primary key". Simon suggested "INTEGER primary key" which is *better* -- it means that the PK is also the rowid (saves space in the table) and you don't need a separate index for the PK. See http://sqlite.org/lang_createtable.html#rowid Perhaps Pierr's problem is related to the "usb interface" on the hard drive? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
