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 <> on behalf of 
Hick Gunter <>
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 [] Im 
Auftrag von mukeshkb4u
Gesendet: Donnerstag, 07. Juni 2018 18:12
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 ?


Sent from:
sqlite-users mailing list

 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 mailing list

Reply via email to