On 26 Jan 2015 at 07:33, Hick Gunter <h...@scigames.at> wrote: > It is never a good idea to rely on automatically assigned column names. If you > want reproducible, predictable, release independant column names then please > assign them with the AS clause.
So you're saying that if I do: create table wiggy (a,b,c,d,e,f,g,h); and later do: select a, b, c, d, e, f from wiggy; then I should really be doing: select a as a, b as b, c as c, d as d, e as e, f as f from wiggy; That'll be a bit tedious changing the more than 300 select statements in my app. I notice that in the PHP doc for SQLite result sets, they carefully talk about the "column names returned in the result set" rathe than just "column names", although I suppose that is just to indicate that names may be provided with AS. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
