Does ‘hidden’ apply to normal tables as well as virtual tables? I tried
CREATE TABLE t(x,y,z hidden); select * from t; but it showed all three cols. ________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Hick Gunter <h...@scigames.at> Sent: Friday, June 8, 2018 7:03:56 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] Selecting multiple similar columnname. Adding the attribute "hidden" to a column prevents it from showing up in the expansion of '*' in the select list, while still allowing it to be queried by name. There is no RE matching in the select list; you are expected to know exactly what you want. Having multiple instances of a field or fields in the row suggests that you schema is not properly normalized. This needs to be a concious design decision. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von mukeshkb4u Gesendet: Donnerstag, 07. Juni 2018 18:12 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Selecting multiple similar columnname. Hi All, I have a table with multiple similar column names, like abc_1,abc_2,abc_3....... Is there a way i can do a select on only these columns in a table, without specifiying the full column list? Can i use a regular expression in selecting column names ? Regards Mukesh -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ 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
