jeudi 26 mars 2015

selecting table columns without one

I have a problem with selecting Sqlite query:



SELECT * from (select*from sqlite_master ) where type='table' and name=?;


Or like this:



SELECT * from sqlite_master where type='table' and name=?;


What it does is that it gets table data from my online Sqlite database, but I need it to show every column except 1st one ( my database columns: first one is called the same as the table and its my primary key, and other columns are like "Period" "Demand" etc. So what i really need to get from select are all those other columns except first one. That "?" represents what my combox says so it switches between tables.


Aucun commentaire:

Enregistrer un commentaire