Makes sense, thanks. For one-offs and things like the "Copying from one table to another" thread that aren't going to be part of a regular running program it's easy enough to use the alias version.
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Monday, November 21, 2016 4:33 PM To: SQLite mailing list Subject: Re: [sqlite] Table name syntax 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
