Under the Sqlite3 shell, press the UP and DOWN ARROW keys to navigate through the history command, and press the left and RIGHT arrow keys to move the cursor to any character position in the command, so you can modify the wrong statement or the character that was knocked out. So the directional key is the most common function under the sqlite3 shell. Under Debian (including Ubuntu), the Sqlite3 Shell arrow key is not working by default. This problem is intentional because the command-line editing feature is externally dependent, and the maintainer of the Sqlite3 binary package does not falsify the available external libraries, These external libraries are not referenced by default, otherwise the binary package may not be available. command-line editing features depend on the external library is ReadLine, under Debian/ubuntu, usually ReadLine library is already installed by default (such as my Ubuntu 11.10 Desktop version of the default already installed the three package Readline-common, Libreadline5, Libreadline6), but Sqlite3 needs to detect ReadLine's header files during the compile phase, so we have to install the dev package: sudo apt-get install Libreadline6-dev Libreadline-dev Pit Daddy is, I use NetEase source without ReadLine Dev package, Google, find here 11.10 corresponding. deb format package:? https://launchpad.net/ubuntu/oneiric /I386/LIBREADLINE6-DEV/6.2-2UBUNTU1HTTPS://LAUNCHPAD.NET/UBUNTU/ONEIRIC/I386/LIBREADLINE-DEV/6.2-2UBUNTU1 dpkg- I libreadline-dev_6.2-2ubuntu1_i386.debdpkg-i Libreadline6-dev_6.2-2ubuntu1_i386.deb Download with 11.10 version of the Sqlite3 source code (3.7.7), recompile, install, enter the Sqlite3 shell and find that the problem has been resolved. Enjoy it!
Sqlite3 Shell arrow key, Browsing History command is not available
