티스토리 뷰
.headers on
.mode columnsqlite> .headers on
sqlite> .mode column
sqlite> select * from mytable;
id foo bar
---------- ---------- ----------
1 val1 val2
2 val3 val4참고)
How to get a list of column names on Sqlite3 database?
https://stackoverflow.com/questions/947215/how-to-get-a-list-of-column-names-on-sqlite3-database
How to get a list of column names on Sqlite3 database?
I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select
stackoverflow.com
댓글