close Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_fs.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.

Changes between Initial Version and Version 1 of wade/sqlite


Ignore:
Timestamp:
Jun 28, 2011, 4:42:42 PM (13 years ago)
Author:
wade
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • wade/sqlite

    v1 v1  
     1[[PageOutline]]
     2
     3
     4= note =
     5 * sqlite 3 轉 CSV。
     6   {{{
     7   sqlite [your filename]
     8   
     9   // 輸出標頭
     10   .header ON
     11
     12   // 輸出 csv
     13   .mode csv
     14
     15   // 以 tab \t 做為分隔符號
     16   .separator "\t"
     17
     18   // 將結果輸出到 test.csv
     19   .output test.csv
     20
     21   // 產生搜尋結果並輸出到 test.csv 內
     22   select * from [table_name]
     23   }}}
     24
     25= Reference =
     26 * http://www.sqlite.org/sqlite.html