Changes between Initial Version and Version 1 of wade/sqlite

Timestamp:

Jun 28, 2011, 4:42:42 PM (14 years ago)

Author:

wade

Comment:

--

wade/sqlite

@@ +1 @@
+[[PageOutline]]
+
+
+= note =
+ * sqlite 3 轉 CSV。
+   {{{
+   sqlite [your filename]
+   
+   // 輸出標頭
+   .header ON 
+
+   // 輸出 csv
+   .mode csv 
+
+   // 以 tab \t 做為分隔符號
+   .separator "\t" 
+
+   // 將結果輸出到 test.csv
+   .output test.csv 
+
+   // 產生搜尋結果並輸出到 test.csv 內
+   select * from [table_name]
+   }}}
+
+= Reference =
+ * http://www.sqlite.org/sqlite.html