I keep running into a problem working with SQLite in the terminal. Sometimes when I enter a command I'll start seeing "..." like this:

sqlite> .import "countries.txt" Country
sqlite> select * from country
...> select * from Country

No matter what I do, I can't get anything else to work. I just keep getting ...> over and over. I understand from the SQLite site that this means it's a continuation and it's waiting for more info, but I don't know what to do. Can anyone help?

If you post a copy of your terminal session from the creation of the database to the problem, a solution should be able to be arrived at. Based on what you have posted there is a strong hint, but it will be clearer with a full listing.

Bob

Did you put a semi colon ; at the end of the statements?

do not put \t in quotes

I'm sorry I've been so late in responding. I was borrowing the book from my boss, and he needed it back, so I haven't been working on it. Once I get back to it I'll see if I can work it out.

Thanks for your replies.