On 11/21/16, Don V Nielsen <donvniel...@gmail.com> wrote: >> And since the "*" forms are considered bad style > > I have done this, not knowing it is bad style. Can you provide some reasons > why it is bad?
Years later when somebody does "ALTER TABLE ... ADD COLUMN" your application will begin doing unnecessary work to extract columns that or not used (best case) or fail completely when it gets back a different number of columns from what it expected (worst case). Or, somebody my use the techniques outlined in https://www.sqlite.org/lang_altertable.html#otheralter to change the order of the columns in the table, which would definitely break your application. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users