On 11/11/2013 9:23 PM, Igor Korot wrote:
I downloaded and installed the command line SQLite3 tool on my Windows box.
What I don't understand now is to how to cancel the long operation.

Suppose I need to do this:
sqlite3> CREATE TRIGGER
--------> mytabe_insert AFTER INSERT ON
-------->

now at this point I need to cancel the trigger creation.

Hitting Ctrl+C will push me to the command prompt and not back to sqlite3.
Hitting ESC will not work.

Is there a way?

Type semicolon then Enter. The statement is malformed - you'll get an error message to that effect, and will be back at sqlite prompt.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to