sqlite3 .import


Last Updated:

  1. Rootstonian

    Rootstonian Member This Topic's Starter

    Joined:
    Nov 25, 2010
    Messages:
    16
    Likes Received:
    0
    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 This Topic's Starter

    Joined:
    Nov 25, 2010
    Messages:
    16
    Likes Received:
    0
    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...