Sqlite: SELECT * BUT id FROM Table Sqlite: SELECT * BUT id FROM Table sqlite sqlite

Sqlite: SELECT * BUT id FROM Table


sql sqlite select

Absolutely, no.

But here's a workaround. Create a VIEW of the table, eg

CREATE VIEW ViewNameAS    SELECT col1, col2, col3, .... -- don't select the column name you want to hide    FROM tableName;

once the VIEW was created, you can now call it,

SELECT * FROM ViewName

sql sqlite select

No, you cannot do that.

You list the ones you need, or you accept that the result set contains one more column than you need.

sql sqlite select

sqlite is an embedded DBMS, and it is expected that some functionality can be implemented with the host language. For instance, stored procedures are excluded since all such advanced logic and flow structures will exist in the host language.

If one thinks outside of SQL, the answer is "yes": Use the host language to iterate through a table's columns and build a select statement to get desired schema. See How can I get the list of a columns in a table for a SQLite database?

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last