1. Check out our app, Forums for Android! Download and leave feedback here!

sqlite3 .import

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

  1. Rootstonian

    Rootstonian Member
    Thread Starter
    15

    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 Member
    Thread Starter
    15

    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...