Sample Header Ad - 728x90

SQLite3 command line: how do you cancel a command?

27 votes
1 answer
14587 views
I made a mistake writing a command at the SQLite command prompt, which I now want to abort, this is how my command line looks sqlite> select * from todos' ...> ' ...> ;^C In this case, likely because I have opened a quote, I can't even hit ENTER to run the command. I just get a line continuation, that would still be less than ideal because I would be having to run bad code and cause and error, just to regain control of the prompt. How can I cancel the line/command and get returned back to a prompt?
Asked by the_velour_fog (12770 rep)
Jun 21, 2016, 08:33 AM
Last activity: Jul 11, 2024, 07:38 AM