I am trying to populate a SQLite database from a csv file on Ubuntu 11.04. I ran the following commands:
create table data1 (id integer, city text, bank text, address text);
.separator ","
.import atm_list_india_updated.csv data1
Could anyone tell me what is going wrong? Why am I getting this error?
sqlite> .tables // shows there is a table called data1
data1
sqlite> select * from data1
...> ;
sqlite> .import *******.csv data1;
Error: no such table: data1; // tells there is no table called data1
sqlite> .show
echo: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
separator: ","
stats: off
width:
sqlite>
As well as other dot-commands that are SQLite shell builtin commands, the .import
command should not terminate with a semicolon.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With