How to repeat last sql command executed on sqlite command line?

Question

I am using android sqlite3 command line tool. How can I repeat the last command I executed (similar to / in sqlplus)? I tried the arrow and. - Both did not work. I am on a Mac :(

Answer 1

Now I get into the same problem.

When I type up , it prints ^[[A

when I type left , it prints ^[[D And it looks like down and right

And I found this question ( Sqlite using the command line ) and posted it.

First rename sqlite3 to sqlite3_bak in Android tools to disable it, or you can delete it directly if you can make sure you won't use it again.

Secondly, download the autoconf source from http://www.sqlite.org/download.html (second link, currently at http://www.sqlite.org/sqlite-autoconf-3071502.tar.gz ):

then cd to the unpacked directory and compile it through the terminal

 $ ./configure $ make $ sudo make install 

Thirdly, put your "new sqlite3 binary" in the /opt/local/bin or set a soft link for it. And specify your .bash_profile or .bashrc .

Answer 2

Perhaps I just introduced this and I can’t check it now, but can you just press the up arrow?