Difference between revisions of "python sqlite notes"

From thelinuxwiki
Jump to: navigation, search
(Created page with " [https://codereview.stackexchange.com/questions/115863/run-query-and-insert-the-result-to-another-table Run query and insert the result to another table] category:pyth...")
 
 
Line 1: Line 1:
 
+
show columns
 
+
sqlite> PRAGMA table_info(table_name);
 +
==links==
  
 
[https://codereview.stackexchange.com/questions/115863/run-query-and-insert-the-result-to-another-table  Run query and insert the result to another table]
 
[https://codereview.stackexchange.com/questions/115863/run-query-and-insert-the-result-to-another-table  Run query and insert the result to another table]

Latest revision as of 04:35, 15 May 2019

show columns

sqlite> PRAGMA table_info(table_name);

links

Run query and insert the result to another table