raspbmc: Unable to exit sqlite3 after incorrect syntax even with semicolon

Question

I was using sqlite to connect to MyVideos75.db when I noticed that the usual method of getting "un-stuck" from the sqlite prompt (entering a semicolon) wasn't working:

pi@raspbmc:~/.xbmc/userdata/Database$ sqlite3 MyVideos75.db 
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from files where strFilename like %Recreation%';
   ...> 
   ...> ;
   ...> ;
   ...> .quit
   ...> ;
   ...> .exit
   ...> ;
   ...> 
   ...> ;
   ...>

So... how do I get myself out of the prompt if .quit, .exit, and ; all don't work?

score 4 · Accepted Answer · answered Mar 04 '14 at 17:45

Figured it out when I opened it up in a tmux window because it was getting annoying to keep killing the terminal tabs; just do a ctrl+D and that will dump you back in the shell:

sqlite> select * from files where strFilename like %Recreation%';
   ...> 
   ...> ;
   ...> ;
   ...> .quit
   ...> ;
   ...> .exit
   ...> ;
   ...> 
   ...> ;
   ...> 
Error: incomplete SQL: select * from files where strFilename like %Recreation%';

;
;
.quit
;
.exit
;

;
pi@raspbmc:~/.xbmc/userdata/Database$

raspbmc: Unable to exit sqlite3 after incorrect syntax even with semicolon

1 Answers1