1. Download our Official Android App: Forums for Android!

Apps sqlite3 .import

Discussion in 'Android Development' started by Rootstonian, Dec 7, 2010.

  1. Rootstonian

    Rootstonian Newbie
    Thread Starter
    Rank:
    None
    Points:
    15
    Posts:
    16
    Joined:
    Nov 25, 2010

    Nov 25, 2010
    16
    0
    15
    Having some problems:

    1. Create 2 row ASCII text file as "testfile"
    abc, def, ghi
    jkl, mno, pqr

    push it to emulator database directory. go into adb shell, navigate to databases directory and "cat" it.
    PROBLEM ONE: I only see the last row, eg jkl, mno, pqr

    2. create table "testtable" and run .import testfile testtable
    PROBLEM TWO: works, but testtable has the data as "jkl", "mno", "pqr" -- why does is it insert data with the quotes (testfile has no quoted data!)

    Thanks!
     

    Advertisement

  2. Rootstonian

    Rootstonian Newbie
    Thread Starter
    Rank:
    None
    Points:
    15
    Posts:
    16
    Joined:
    Nov 25, 2010

    Nov 25, 2010
    16
    0
    15
    ok, this is freaking weird...I just went back to the shell and selected the data...the quotes are GONE! what da hell. And I have a terminal session open that shows the 2 selects: one with quotes and know one without. Scary. Now just need to fix problem one...probably and end-of-line thang
     

Share This Page

Loading...